Share via

font color using if function

Anonymous
2015-12-28T09:25:54+00:00

i have a formula using if function, if the formula to return FALSE, i want the font to be colored red or any other color (not the cell). thank you very much!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2015-12-28T09:31:11+00:00

Hi,

Let's say this formula is in A1. Select A1 then:-

Home tab | conditional formatting | new rule | use a formula to decide which cells to format and enter this formula

=A1=FALSE

Click the format button | font tab | select a red colour from the colour dropdown and OK out. Change A1 in the formula to the correct cell address.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest