DOES NOT EQUAL - Conditional Formatting

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

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".


In article <[email protected]>,
SamuelT <[email protected]> wrote:

> 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

Try removing the outermost set of brackets

Ed

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!!!

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")

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