Conditional formatting--simple question

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

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" <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
>
>

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" <bliengme@stfx.TRUENORTH.ca> wrote in message
news:ety7fRoKGHA.344@TK2MSFTNGP11.phx.gbl...
>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" <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
>>
>>
>
>

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
>
>

On Sun, 5 Feb 2006 13:29:47 -0500, "John Wirt" <mmm@toward.com> 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