View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
chrismears chrismears is offline
external usenet poster
 
Posts: 3
Default 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!