Conditional Formatting using result of Cell Formulas

[Father Guido]

Hi,

I'm trying to make a conditional format when the result of a formula
results in a value being entered in a cell.

I'm using Excel Xp and my formula is as follows.

=IF(F160="Need Info",TODAY()-S160,"")

I've tried using formulas like >0, <>"", <>BLANK etc. but they all
seem to fail. All cells are formatted, even entirely blank cells, as
if the condition has been met.

BTW, is this formula better strategically than the above formula.

=IF(F160<>"Need Info","",TODAY()-S160)

Just curious.

TIA!!!

Norm

 

[Dave Peterson]

If that cell to be formatted is A1, how about:
Formula is:
=A1=""

or
=A1<>""

(Top one formats if the formula returns "". Bottom one if the formula returns
that number.)

I like the second formula--but that's a personal preference. I find it easier
to see those "" when they're next to what caused them.

But I think the real answer is to use the one you like and be able to understand
both.

 

[Father Guido]

Thanks Dave, that worked perfectly!!!

Norm

On Tue, 25 Jan 2005 20:17:42 -0600, Dave Peterson

~If that cell to be formatted is A1, how about:
~Formula is:
~=A1=""
~
~or
~=A1<>""
~
~(Top one formats if the formula returns "". Bottom one if the
formula returns
~that number.)
~
~I like the second formula--but that's a personal preference. I find
it easier
~to see those "" when they're next to what caused them.
~
~But I think the real answer is to use the one you like and be able to
understand
~both.
~
~Father Guido wrote:
~>
~> Hi,
~>
~> I'm trying to make a conditional format when the result of a
formula
~> results in a value being entered in a cell.
~>
~> I'm using Excel Xp and my formula is as follows.
~>
~> =IF(F160="Need Info",TODAY()-S160,"")
~>
~> I've tried using formulas like >0, <>"", <>BLANK etc. but they all
~> seem to fail. All cells are formatted, even entirely blank cells,
as
~> if the condition has been met.
~>
~> BTW, is this formula better strategically than the above formula.
~>
~> =IF(F160<>"Need Info","",TODAY()-S160)
~>
~> Just curious.
~>
~> TIA!!!
~>
~> Norm