IF Function

  • Thread starter Thread starter DME
  • Start date Start date
D

DME

Is there a way to program an IF statement to change the font color or
boldness in a cell.

Example:

IF(a1="Extra",Color of Font Cell B2 =Black,Leave Font Color White)

What I want to do is that if the end-user chooses "Extra" in cell A1 then I
want the font color to change from white in cell b2 to black font, so the
message will appear on white background. The message will always be typed
into cell B2, I just don't want the end user to see it unless they choose
"Extra".
Any help would be appreciated. Thanks!
 
You cannot use a formula to change the font attributes of a cell.
Instead, use Conditional Formatting from the Format menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Use Conditional formatting to solve this. In this case, in cell B2, using the menu bar, select (F)ormat Con(d)itional then select FORMULA IS in the drop down box. In the box next to it, type (=$A$1="Extra") without the parenthesis. Make sure you put quotes around the word "Extra"). Click on the Format Box, then select the PATTERNS tab. Click on the black box.

Should work!

Leah
 
Thanks! Exactly what I wanted.


Leah said:
Use Conditional formatting to solve this. In this case, in cell B2, using
Click to expand...
the menu bar, select (F)ormat Con(d)itional then select FORMULA IS in the
drop down box. In the box next to it, type (=$A$1="Extra") without the
parenthesis. Make sure you put quotes around the word "Extra"). Click on
the Format Box, then select the PATTERNS tab. Click on the black box.
 
Back
Top