Conditional Formatting

[jkgreen]

I have a cell containing a formula that will return either a percentage value or and "NA". I want to format negative percentage value in red cells, positive percentage values in green cells and the "NA" in white cells. Any idea how to get those "NA" cells white? Right now they are all green.

 

[Mtyler]

You could always try changing the formula so that instead of N/A it gives a text string of "ERROR". Then you can conditional format based upon "equals to" "ERROR"...

 

[jkgreen]

I got it. I needed to change the order of my rules. The NA rule needed to be first.