Hi all,

I'm trying to apply some conditional formatting to a range of cells where, if the cell DOES NOT EQUAL the value "FALSE" and another cell contains the word "Red" (there's more colors, but that's academic) then formatting occurs.

In the conditional formatting box, I've entered the following formula:

=(AND(D3<>"FALSE",$DA3="Red"))

I thought the "<>" would indicate does not equal, or at least give the same results, but no joy.

Any ideas?

TIA,

SamuelT