Hi!

You don't need the quotes around the formula. Sometimes under certain
conditions the cf user form does that. You can just edit those out.

Or, use this formula:

=C13<D13

Biff

"John Wirt" <mmm@toward.com> wrote in message
news:eioiREoKGHA.360@TK2MSFTNGP12.phx.gbl...
> 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
>
>