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
 
Well, the date has now passed, and Windows 10 is no longer supported. Hopefully, the readers of this forum have done one of the many ways this issue can be handled. If not, do a YouTube search and a smorgasbord of solutions will be returned. What I want to mention is that I chose to use a debloated Windows from a debloater. There are many available options, e.g., Chris Titus Utilities (I used a product called Velotic, which also features AI to prevent your computer from overheating etc...
I have been idly browsing what Apple have to offer with their new iPhone17. There is mention of 'Vapour cooling' to deal with the heat generated. Would that be the same sort of idea that was used in 'Heat Pipes' where water evaporated at the processor end and liquid water was returned from the cool end and back along a wick. At the extreme high power end, Vapour Phase Cooling has been used in multi-kW RF transmitters where (pure) water was pumped to the Anode / or alternative Collector and...
Back
Top