AM I USE FONT COLOUR IN IF FUNCTION IN EXCEL

[Guest]

how can i use the color codes or font colour in if function

 

[JulieD]

Hi

use format / conditional formatting instead - basically select the cell that
you want to apply the colour to, choose format / conditional formatting,
choose the comparison operator, type in the value to compare to and click on
the format button to choose the formatting you want.

you have up to three formats per cell (range). It is possible to get more
if you need them using a variety of methods.

please post back if you have additional questions.
Cheers
julieD

 

[Myrna Larson]

You can't. In your formula you include whatever logic was used to apply the
color or font color in the first place.

On Mon, 22 Nov 2004 02:47:03 -0800, "Rizwan Asghar" <Rizwan