Using Color in If formulas 1

[sjp2345]

I am using the if function and if the statement is true, I want the cell to be Jan(in red font) and if it is false, I want the cell to be Jan(in black font).

How do you get the color to carry over with the if formula?

 

[JPaules]

So regardless of whether it's true or false , the answer will be the same?

--
JP

 

[sjp2345]

The answer will be Jan regardless but one should be Jan and the other should be Jan.

 

[SkipVought]

Did you not understand the answer in thread68-1507920???

Skip,

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

 

[sjp2345]

No I did not

 

[SkipVought]

What was it that you did not understand? It is not acceptable to open a new thread addressing the same issue. Please post your questions in thread68-1507920.

Skip,

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

 

[mscallisto]

use the formula to generate the Jan then use the same formula in a "Conditional Format" to set the font to Red.