On Sun, 5 Feb 2006 13:29:47 -0500, "John Wirt" wrote:

Why does this conditional formating statement not work?

="IF(C13<D13,1,0)"

WHen I apply this conditional format to a cell in G13, it has no effect on
the format of the number in G13. The format is to cross-hatch the cell
pattern if the condition is true.

I have tried, "IF(C13<D13,1,0)," which makes no difference.

Thank you.

John Wirt


The enclosed double quotes causes Excel to treat your "formula" as a string of
text. So it will only match if G13 contains that text AND if you are using the
Cell Value Is option.

What you probably want is the Formula Is: option.

In addition, since all you need is something that will return TRUE or FALSE, it
would be simpler to use the formula:

=C13<D13

instead of the IF(...) formual.


--ron