Question related to Conditional Formatting

Super Contributor

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 of the problem I am facing,

In the below screenshot I want to highlight the word "Pete" , but as i do so , along with "Pete",  "petel" is also getting highlighted.

please find the below screenshot for your reference    

Screenshot (5529).png


So, i want to highlight Pete only with the help of Conditional Formatting.


Please Help..??


Here is a attached file..


4 Replies


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



See the attached version.

@Zan_Hanifee Change the rule to this:

Screenshot 2021-12-06 at 14.50.33.png

Thank you so much sir
Thank you so much sir.