Did you check cell H2 for extraneous leading or training blanks and for case mismatch?
If you have a spare cell on the worksheet, you can copy and paste (not retype) that formula into the cell and see if it evaluates to TRUE or FALSE.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I am having an issue with conditional formatting on an excel spread sheet.
I am trying to have the cell change colour based on a true value, i.e., a specific word, but it will not recognize the words "Low" or "Medium" I can use the words "High" or "Extreme" with successful results.
The formula is: =$H2="Extreme"
When I substitute "Extreme" for the words Low or Medium it will not recognize the true value.
Any thoughts??
Did you check cell H2 for extraneous leading or training blanks and for case mismatch?
If you have a spare cell on the worksheet, you can copy and paste (not retype) that formula into the cell and see if it evaluates to TRUE or FALSE.
Hi @Colin M
On my test environment, conditional Formatting formulas work correctly with text "Low" or "Medium".
Please refer to Barry Schwarz's suggestion.
Make sure that in data range and conditional formatting formulas, there are no spaces in front of the text and the capitalization is consistent.
If there is no problem with the text, it is recommended that you delete important and private data, save the Excel workbook as a file in .xml format, and upload it to the Q&A forum. I will do further inspection.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.