Is there a formula to AUTOMATICALLY highlight a specific month
To quote the Dire Straits song, "That's the way you do it!"
Tried it and it works wonderfully, I was so close. Thanks guys!
"Bob Phillips" wrote:
In that case, use a formula of =MONTH(A1)=3
--
HTH
RP
(remove nothere from the email address if mailing direct)
"chrismears" wrote in message
...
Tried this (no luck). Dates are complete (yyyy-mm-dd), but formatted to
show
as only (mmm-yy).
tried to apply a conditional formatting formula, but either it highlighted
everything, or just nothing. Thanks for the help!
|