Color Value From If

[sotiris_s]

here is the problem: I want to highlight the value from an If function, lets
say the false one, to give me the disired value in a color {red would be
applicable}, so
when i look at the list i can easyly find out what is the value that
came/genarated from the False option.

Thank you very much for your time
Sotiris

 

[Frank Kabel]

Hi
use 'Format - Conditional Format' for this

 

[sotiris_s]

well how i will do this? we have the clasical if formula and the excel gives
me the format if the value is true, so? {it seams i can't figure it out}
thank you anyway

 

[Frank Kabel]

Hi
post the values you could have from this formula (and post the exact
formula).

The important thing is: A formula itself can't change a format

 

[sotiris_s]

ok i will give the formula its simple one but the goal is to show which
values are not compromise with the formula, in order to highlight them......

i have the values at the range AM4:AV4, The Geomean of those at CA4 and i
want to use the algorithm ((abs(AM4-CA4))/CA4)>(CA4*0.8) IF true AM4
ELSE take again the AM4 value BUT instead change the color...... i thought
that it was possible with an if command and to enter the [RED] at the begging
of the False statement.... the hole story is have an easy to eye red blinks
in a trilion of data so i can eliminate them......

thank you for your time....

{of course the collums AM:AV & CA goes up to 400 row or beyond}

 

[Frank Kabel]

Hi
you have to enter this kind of formula in the conditional format
dialog. e.g. select the relevant cell, goto this dialog, choose
'formula is' and enter
=((abs(AM4-CA4))/CA4)<=(CA4*0.8)
and choose a red color.

As said: No was to add a [red] flag in the formula directly

--
Regards
Frank Kabel
Frankfurt, Germany

ok i will give the formula its simple one but the goal is to show which
values are not compromise with the formula, in order to highlight them......

i have the values at the range AM4:AV4, The Geomean of those at CA4 and i
want to use the algorithm ((abs(AM4-CA4))/CA4)>(CA4*0.8) IF true AM4
ELSE take again the AM4 value BUT instead change the color...... i thought
that it was possible with an if command and to enter the [RED] at the begging
of the False statement.... the hole story is have an easy to eye red blinks
in a trilion of data so i can eliminate them......

thank you for your time....

{of course the collums AM:AV & CA goes up to 400 row or beyond}

Hi
post the values you could have from this formula (and post the exact
formula).

The important thing is: A formula itself can't change a format

--
Regards
Frank Kabel
Frankfurt, Germany

it
out} {red
would be value
that