Excel 2016 Conditional Formatting highlighting wrong cells

Question

I simply want the rows with the word 'Evening' in the E column to highlight.  

I used a formula to determine which cells to format: =$E2="Evening" and asked it to fill blue.

It is filling in some rows that have daytime listed in the E column instead of evening. It is also filling in some that say evening.  There doesn't seem to be any rhyme or reason to it.  I'm not sure what I'm doing wrong.

Any advice would be appeciated.

Answer 1

Hello Kelly,

Do you want the formatting according to the word "Evening" or based on any "values"?

Please mention the steps on how you are formatting the rows.

If you are going with the "text", create a rule like this:

Under Home tab, click Conditional formatting, New Rule, Select "format only cells that contain" and in the Rule Description, select specific text in the drop down containing and select the 2nd row in E column (=$E$2) and select format to pick the color.

Hope this helps. Let us know if you have any queries.

Thank you.