•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to create a spreadsheet where cells are highlighted if name of month typed matches current month
I'm trying to create a spreadsheet for our office manager to help keep track of birthday months and anniversary months of employees.
What I'm trying to do is create a row in which employee birthday months are typed (March, April, etc) - and not exact full dates.
I want to create conditional formatting where all of the text values that match the current month are green, so she can scroll through each month and make a quick list of anyone with a birthday/anniversary that month.
We will not have full birth or anniversary dates, just the name of the month.
I have tried all sorts of formulas from google searches, to no avail.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com