Hi,

Lets say you have your birthdays in Column A starting in A1. Select all the
dates and then

Home Tab - Conditional formatting - New rule -
double click 'Use a formula to determine which cells to format'
enter the formula
=month(A1)=Month(now())
Click 'Format' - Fill tab
select your colour OK

Now any birthday in the current month will be highlighted and it will update
as the month changes


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Onflight1978" wrote:

Hi all.. so I am pretty new with Excel 2007...so here's the scenario I need
help with.

I would like to either create a formula or macro that would analyze a column
that's filled with dates and to highlight the dates based on the month only.

Basically it's a colum full of birthdays..and I want to pull up my
spreadsheet and have the people's birthday highlighted by current month so
they can be recognized.

Thanks for the help and input!