Conditional Formatting for multiple criteria

  • Thread starter Thread starter Craig860
  • Start date Start date
C

Craig860

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?
 
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?
 
Back
Top