Changing colors with an If statement

[mlopes1]

I have the following code in a range of cells in column B:
=IF(ISBLANK(C12),"N/A","Other terms:")

The C12 is not constant.

Is there a way to have the formula make the "N/A" be shown with black font and the "Other terms:" in red?

I am sure this has been asnwered before but I could not find it in previous posts. Thanks in advance,

Mark

 

[phantom1975]

You can do this with conditional formatting. You will need to set the formatting to FORMULA and put the following:

="N/A"

Then you can set the color that you want.

Did this help?

 

[mlopes1]

Yup, that did it. So simple!

Thank you