Adding Color options in @if functions.

[cgtrucking]

I am trying the following formula in Excel 2003 & 2007

@if(c51>100,b83,b84) Cell B84 is in red font. When the results come back to cell c51 it comes back in black font.


It should come back Apr(in red)
Any help would be appreciated.
Thanks
Fran

 

[SkipVought]

Hi,

"It should come back Apr(in red)"

Do you have a conditional format set? Otherwise the font color is the default color. The =IF statement has nothing to do with formats--just Values.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}