SO i have something for work i'm trying to figure out, i'm no excel expert in any way.
I have a spreadsheet with measurements taken from other software.
What i have now works, which is the cell with the value will look up another cell to check if it's above or below the desired value, a simple red for bad green for good, this works okay.
What i want to know is if there is someway i can add a way to highlight the cell another way if it's within 10% say of the upper limit.
example
upper limit 53.63
ideal 58.13
lower 58.63
I.E
Currently, above upper goes red, but i would like say orange if the value is say 58.53, is that possible?
I have a spreadsheet with measurements taken from other software.
What i have now works, which is the cell with the value will look up another cell to check if it's above or below the desired value, a simple red for bad green for good, this works okay.
What i want to know is if there is someway i can add a way to highlight the cell another way if it's within 10% say of the upper limit.
example
upper limit 53.63
ideal 58.13
lower 58.63
I.E
Currently, above upper goes red, but i would like say orange if the value is say 58.53, is that possible?