"Rick Rothstein (MVP - VB)" wrote in
message ...
If you store the birthdays as text, say, like this... Mar 8, July 23,
November 13, etc., then you can form the current years birthday in a
column using this formula...

=--(B2&", "&YEAR(NOW()))

You can then apply your current highlighter formula to that date.

Thanks for that suggestion.

Actually I like storing the dates as DOBs since then I also know which
birthday is being celebrated this year (in case it's a 'special' one!).

V