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.
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.
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.