I've 3 columns in a spreadsheet and I want to highlight the values in column
value based on the bounds specified in columns
If the number in column
value lies within the range [min, max], the cell has to be highlighted green. If the number is less than
min or greater than
max the cell has to be highlighted red. And if there is no value in
value, the cell has to be colored yellow.
Suggestions on how to define the rules for conditional formatting in excel will be really helpful.