Conditional formatting issue

Colin M 0 Reputation points
2024-04-19T13:51:08+00:00

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??

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Barry Schwarz 3,071 Reputation points
    2024-04-19T17:50:56.7966667+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments

  2. Jiajing Hua-MFST 10,560 Reputation points Microsoft Vendor
    2024-04-22T06:12:41.49+00:00

    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.



Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.