View Single Post
  #1   Report Post  
David
 
Posts: n/a
Default Conditional Formatting based on month name

I have a sheet where C2 contains the typed text of a month, i.e. February.
Range C4:D14 contains actual dates spanning several months. I would like to
highlight the cells that contain the month in C2. I've floundered around
for several hours without a solution. Any help?

P.S. I need C2 to remain text so it won't change until I change it.

--
David