Hi,

Select B1
Format|Conditional format - Formula is
=AND($B$1<A1,B1A1-30)
Select green
Add
Cell value is - Greater thanh equal to
=$A$1
Select red
OK

Mike


"Sibbs" wrote:

Hi Guys, hopefully someone might be able to help me.

My small problem is this

With a an examination date in say, Cell A1, I would like B1 to Flash up
"green" when the date in B1 is within 1 Month of the date within A1 and "Red"
when the date is past the date in A1. Hope that makes sense.

Cheers i advance