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