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
|