conditional formatting - problem with text cell value from formula
I wish to apply conditional formatting with three conditions based on the
cell value, resulting in three different shading colors. The cells have
formulae with if statements that return "n/a" if one of the referenced cells
contain "n/a" or are blank.
this results in the conditional formatting applying the color for the
condition 0 when the cell value is "n/a" - i want it to leave these alone
(i.e. no color)
please help
|