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