How to Use REGEXMATCH for Highlighting the Current Month?

  • Thread starter Thread starter Steven Ellet
  • Start date Start date
AI Thread Summary
To highlight the current month in Excel using REGEXMATCH, the existing formula checks for "May" but needs to be modified for dynamic cell lookup. A suggested approach is to replace "May" with a formula that retrieves the current month's name based on the current date. The provided lengthy formula uses nested IF statements to return the month's name corresponding to the current month number. This can be applied to highlight cells in columns B and C. The discussion concludes with a reference to a resource for further guidance on highlighting the current month in Excel.
Steven Ellet
Messages
85
Reaction score
3
Current Formula =IF(REGEXMATCH(B1,"May"), 1, 0)
Problem: I am trying to find a way to replace "May" with a cell lookup.
Goal: Highlight any cell with current month (in this case, May) in B:B or C:C (if I need 2 formulas, that is fine)
Extra info:
Cell lookup: =IF((MONTH(TODAY()))=1,"January",IF((MONTH(TODAY()))=2,"February",IF((MONTH(TODAY()))=3,"March",IF((MONTH(TODAY()))=4,"April",IF((MONTH(TODAY()))=5,"May",IF((MONTH(TODAY()))=6,"June",IF((MONTH(TODAY()))=7,"July",IF((MONTH(TODAY()))=8,"August",IF((MONTH(TODAY()))=9,"September",IF((MONTH(TODAY()))=10,"October",IF((MONTH(TODAY()))=11,"December",IF((MONTH(TODAY()))=12,"May"))))))))))))
 
Computer science news on Phys.org
Case solved
 
Thread 'Urgent: Physically repair - or bypass - power button on Asus laptop'

Thread 'Urgent: Physically repair - or bypass - power button on Asus laptop'

Asus Vivobook S14 flip. The power button is wrecked. Unable to turn it on AT ALL. We can get into how and why it got wrecked later, but suffice to say a kitchen knife was involved: These buttons do want to NOT come off, not like other lappies, where they can snap in and out. And they sure don't go back on. So, in the absence of a longer-term solution that might involve a replacement, is there any way I can activate the power button, like with a paperclip or wire or something? It looks...
View full post »

Thread 'Google DeepMind, AI/ML and ALPHA-fold'

I came across a video regarding the use of AI/ML to work through complex datasets to determine complicated protein structures. It is a promising and beneficial use of AI/ML. AlphaFold - The Most Useful Thing AI Has Ever Done https://www.ebi.ac.uk/training/online/courses/alphafold/an-introductory-guide-to-its-strengths-and-limitations/what-is-alphafold/ https://en.wikipedia.org/wiki/AlphaFold https://deepmind.google/about/ Edit/update: The AlphaFold article in Nature John Jumper...
View full post »

Similar threads

Need Help with Fortran compiler errors
Replies
12
Views
4K
Limiting Future Dates on Android Studio Date Picker
Replies
4
Views
2K
I Filling in Missing Values in a string of data
Replies
7
Views
1K
Are Home Termite Warranties Worth It?
Replies
29
Views
5K
How to Smoothly Distribute Monthly Data Values Across Daily Intervals?
Replies
2
Views
2K
Is Pink Floyd's Dark Side of the Moon Still Relevant After 50 Years?
Replies
44
Views
5K
C/C++ How Can I Generate a Calendar in C++ Using User Input for First Day and Month?
Replies
2
Views
12K
Merge sort with array of structs
Replies
6
Views
8K
Is 6 months of intense study enough time to study for an entrance exam
Replies
15
Views
4K
Heard anything about GPB results?
Replies
11
Views
5K

Hot Threads

Recent Insights

Back
Top