Color Value From If
 

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

Hi
use 'Format - Conditional Format' for this

"sotiris_s" wrote:

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

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

Hi
use 'Format - Conditional Format' for this

"sotiris_s" wrote:

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

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

"sotiris_s" schrieb im Newsbeitrag
...
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" wrote:

Hi
use 'Format - Conditional Format' for this

"sotiris_s" wrote:

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

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

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

"sotiris_s" schrieb im Newsbeitrag
...
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" wrote:

Hi
use 'Format - Conditional Format' for this

"sotiris_s" wrote:

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

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

"sotiris_s" schrieb im Newsbeitrag
...
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" wrote:

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

"sotiris_s" schrieb im
Newsbeitrag
...
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" wrote:

Hi
use 'Format - Conditional Format' for this

"sotiris_s" wrote:

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