Conditional Format in Excel 2010

SPLUCENA

Board Regular
Joined
Feb 24, 2009
Messages
189
Hi Again,

This will be my first time to use Excel 2010 conditional formatting: I wish to do the following
If the date in column AF is =< today column A fill color red, text in the cell "Contract Expired"
Date in column AF is expiring within the next months column A fill color orange, text in the cell "Send Mail"
Date in column AF is more than 4 months from today's date, column A fill color green, text in cell " Contract Valid"

Thanks for assisting!
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Sparkle99

Board Regular
Joined
May 22, 2009
Messages
109
Using cell A2, input this formula
'=IF(AF2 < TODAY(),"Contract Expired", IF(AF2 < TODAY()+30,"Send Mail", IF(AF2 > TODAY()+120,"Contract Valid","")))<today(),"contract Mail?,IF(AF2="" Expired?,IF(AF2<TODAY()+30,?Send=""><today(),"contract Mail?,IF(AF2="" Expired?,IF(AF2<TODAY()+30,?Send="">
This will set text into the cell.

Then use condiftional formatting based on the formula result

=A2="Contract Valid" (set fill of Green)
=A2="Send Mail" (set fill of Yellow)
=A2="Contract Expired" (set fill of Red)

Copy A2 down the column</today(),"contract></today(),"contract>
 

Watch MrExcel Video

Forum statistics

Threads
1,122,669
Messages
5,597,470
Members
414,145
Latest member
lonnie451

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