Cell Font Color Help

YUPAPA

New Member
Joined
Sep 3, 2002
Messages
2
How do you change the font color of a cell?

Lets say B2-B1 < 5, B3 = Red Color

I know the IF statment for this, but I do not know the code to change the font color of the cell B3. Can anyone help?

IF(B2-B1<5,B3*HowToChangeTheFontColorToRed*,0)
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
1,570
Welcome to the board YUPAPA,

You can do it with Conditional Formating.

1- Select B3
2- Click Format _ Condition Formatting
3- Set condition1 to "Formula is" in drop down box in the Conditional Format dialog window
4- Write this formula in Condition text box

=B2-B1<5

5- Click Format on Conditional Format dialog box
6- Set color to red, Ok.
7- Click Ok to apply your conditional formatting and close dialog box.

Now your cell will be red if your condition is true.

Regards
Suat
 

elgringo56

Well-known Member
Joined
Apr 15, 2002
Messages
869
YUPAPA, experment with the macro recorder, record some macros changing font colors. This will show you the various numbers to use and the command structure to use. Then you can copy/paste into an IF or just type them in.
 

Forum statistics

Threads
1,144,438
Messages
5,724,361
Members
422,546
Latest member
KevinOnTheDaily

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top