Conditional Formatting - Dates.

  • Thread starter Thread starter MrAlMackay
  • Start date Start date
M

MrAlMackay

Could anyone help with the following conditional formatting questions. Have a
spreadsheet with a list of training dates, need to be able to apply the
following conditions:

1) Colour the cell in Amber when the cell contains a date < one month ahead of
today

2) Colour the cell in Green if the cell's date is > 1 month away

3) Colour the cell in Red if the cell's date is < today.

Hope this makes sense, this would mean the following for the dates below:

Cell A1: 7th September 2003 (AMBER)
Cell A2: 10th October 2003 (GREEN)
Cell A3: 1st August 2003 (RED).

Appreciate your help. Many Thanks - Al Mackay ( (e-mail address removed) )
 
Mr Al,

In CF

Select all cells to be formatted (I am assuming A1 is first of these)

Condition1 set to FormulaIs
Formula = A1<=TODAY(), Pattern in Format=Red

Condition2 set tro FormulaIS
Formula = A1<=DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY()))
Pattern in Format is amber

Condition3 set to FormulaIs
Formula = A1>DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY()))
Pattren is green
 
Back
Top