View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Helpme Helpme is offline
external usenet poster
 
Posts: 34
Default conditional formatting

I have three columns of data: column A is start date. Column B is end date
and Column C is date of birth. I need to highlight people who have a Birthday
between the start and the end date.
Can I do this in Excel?
I'm assuming I use conditional formatting but have no idea what the formula
would be. I think this may be easier if i take out the year of birth and just
use the date and month is the right?
Any suggestions would be greatly appreciated, I'm not so hot with Excel and
I'm really stuck!!!