You can use formulas that evaluate to a numeric value.

If the formula evaluates to zero, that's "considered" FALSE. If the formula
evaluates to any other number (including negatives), it's "considered" TRUE.

Biff

"Bernard Liengme" wrote in message
...
I think you are misunderstanding Conditional Formatting. This of it as <if
this formula is true then <use this format. Your formula gives a numeric
value not a Boolean one.
So, with G13 selected, open the Conditional Formatting dialog and enter
=C13<D13 as your formula, then set formatting.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"John Wirt" wrote in message
...
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