Forum Discussion
Question related to Conditional Formatting
Hello Everyone, I tried to conditional format lists from one of the recourses attached to this course , but it is not highlighting the content that i wish to, I have attached the screenshot ...
Your rule is for cells whose value contains "pete". This allows for other text in the cell too.
Change the rule to type 'Use a formula to determine which cells to format' with formula
=LOWER(A2)="pete"
See the attached version.
Thank you so much sir