conditional formatting

H

helpme

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!!!
 
T

T. Valko

Try this...

Assume:

Start dates in the range A2:A10
End dates in the range B2:B10
Birth dates are in the range C2:C10

Select the range C2:C10
Goto the menu Format>Conditional Formatting
Formula Is:

=AND(C2<>"",C2>=A2,C2<=B2)

Click the format button
Select the style(s) desired
OK out
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting dates 3
Conditional Formatting for 6 month intervals (ignoring day and year)?? 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Excel conditional formatting with Weeknum 4
Comparison of columns using Conditional Formatting 3
Calculating age from date of birth and ignoring if blank 5
Excel function to convert month-day-year to mm/dd/yyyy 7
Conditional Formatting (Dates) 3

Top