kausalya durgale
asked on
Regex expression
Hi There, how to write a regex expression to identify string match:
for ex: in my entire workbook it should highlight the summary column, if it contains any string length greater than 6 digits or 8 digit. for ex: if summary column has 6 digit number it should highlight that row, if it has only 8 digit even then it should be highlighted, if it has both 6 and 8 digit it should get highlighted:
attached is the sample
Book1.xlsx
for ex: in my entire workbook it should highlight the summary column, if it contains any string length greater than 6 digits or 8 digit. for ex: if summary column has 6 digit number it should highlight that row, if it has only 8 digit even then it should be highlighted, if it has both 6 and 8 digit it should get highlighted:
attached is the sample
Book1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
hmm... excel does have conditional formatting
https://support.office.com/en-us/article/use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f
https://support.office.com/en-us/article/use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f
»bp