1 min readfrom 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.

submitted by /u/Myworkaccount918
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#rows.com
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#google sheets
#row zero
#financial modeling with spreadsheets
#Excel alternatives