DOES NOT EQUAL - Conditional Formatting

[SamuelT]

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

 

[JE McGimpsey]

Is the value in D3 the text value (word) FALSE, or is it the boolean
value FALSE (as in TRUE/FALSE, perhaps the result of a comparison
formula)?

If the former, your formula works. If the latter, remove the quotes
around "FALSE".

 

[EdMac]

Try removing the outermost set of brackets

E

 

[SamuelT]

Thanks guys.

FALSE was boolean, got rid of the inverted commas, and got rid of the
second pair of brackets. Now everything's working peachily!!!

 

[daddylonglegs]

Note that you might still have a problem if D3 is blank,

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

will return FALSE in that case because the blank is interpreted as
FALSE. If that causes a problem you could use

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

 

[SamuelT]

None of the effected cells are blank. But thanks for the suggestion
anyhow.