View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sibbs Sibbs is offline
external usenet poster
 
Posts: 13
Default Matching specifc dates using Conditonal format

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