Conditional Formatting for multiple criteria
 

cell a1="Yes"
cell b1="True"

Highlight B1 in red only if it is greater or less than True.
I can make it highlight with formula is with one or the other but not have
it look at both fields. Any ideas?

Conditional Formatting for multiple criteria
 

You didn't share the rules for what A1 should be.

If B1 should be red only if it's not True and at the same time A1 must be Yes.

Select the cell(s) to format
Format|conditional formatting (xl2003 menus)
formula is:
=and(a1="yes",b1<"true")
or
=and(a1="yes",b1<TRUE)

Does B1 contain the string True or the boolean TRUE?



Craig860 wrote:

cell a1="Yes"
cell b1="True"

Highlight B1 in red only if it is greater or less than True.
I can make it highlight with formula is with one or the other but not have
it look at both fields. Any ideas?

--

Dave Peterson