Conditional Formatting a range of dates

[ChrisCRC]

Hi Guru's,

I have a workbook with a range of dates. What I want to do is make all cells in the range turn green if the highest date in the range is between the dates in specified cells.

I have the following:


A1= Today() A2= Today()-30

B1:B6= dates that an event took place


I need the whole range to be green if the MAX date is between A1 and A2, then red if it is less than A2.

Please can you help me?

Many Thanks

[AliGW]

Rule for green:

=AND(MAX($B$1:$B$6)<=$A$1,MAX($B$1:$B$6)>=$A$2)

Rule for red:

=MAX($B$1:$B$6)<$A$2)

[ChrisCRC]

Ali,

That works great. Thank you for your help.

Chris

[AliGW]

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.