How to Use REGEXMATCH for Highlighting the Current Month?

  • Thread starter Steven Ellet
  • Start date
In summary, the formula provided uses REGEXMATCH to determine if the cell in B1 contains "May" and returns a value of 1 or 0. The goal is to replace "May" with a cell lookup that highlights any cell with the current month. The extra information includes a cell lookup formula using the MONTH function to determine the current month. The problem has been solved using the provided information.
  • #1
Steven Ellet
85
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
  • #3
Case solved
 

FAQ: How to Use REGEXMATCH for Highlighting the Current Month?

What is REGEXMATCH in Excel/Google Sheets?

REGEXMATCH is a function used in both Excel and Google Sheets that allows users to search for a specific pattern or text within a cell or range of cells. It uses regular expressions, a sequence of characters that define a search pattern, to identify matches within the data.

How do I use REGEXMATCH in Excel/Google Sheets?

To use REGEXMATCH, you need to first select the cell where you want the result to appear. Then, type "=REGEXMATCH(" followed by the cell or range of cells you want to search, a comma, and the regular expression or text you want to find. Close the parentheses and press enter to see the result.

Can I use REGEXMATCH to search for multiple patterns?

Yes, you can use REGEXMATCH to search for multiple patterns by using the "|" symbol to separate each pattern. For example, if you want to search for the words "apple" or "orange" in a cell, you can use the formula "=REGEXMATCH(A1,"apple|orange")". This will return "TRUE" if either pattern is found in the cell.

Are REGEXMATCH searches case-sensitive?

By default, REGEXMATCH searches are case-sensitive, meaning it will only find exact matches of the pattern or text you specify. However, you can use the "i" flag at the end of your regular expression to make the search case-insensitive. For example, "=REGEXMATCH(A1,"apple","i")" will find both "apple" and "Apple" in the cell.

Can I combine REGEXMATCH with other functions in Excel/Google Sheets?

Yes, you can combine REGEXMATCH with other functions to perform more complex searches and return specific results. For example, you can use IF statements to determine what result is returned based on whether the REGEXMATCH finds a match or not. You can also use functions like COUNTIF or SUMIF to count or sum the number of cells that match a certain pattern.

Similar threads

Need Help with Fortran compiler errors
Replies
12
Views
3K
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
Correctly displaying result on Matlab
Replies
1
Views
2K
Are Home Termite Warranties Worth It?
Replies
29
Views
4K
How to Smoothly Distribute Monthly Data Values Across Daily Intervals?
Replies
2
Views
2K
Exploring the Cosmic Connection: Pink Floyd's Dark Side of the Moon at 50
2
Replies
44
Views
4K
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
2K

Hot Threads

Recent Insights

Back
Top