Question related to Conditional Formatting

Iron 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

@Excel 

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"

S0968.png

See the attached version.

@Excel Change the rule to this:

Screenshot 2021-12-06 at 14.50.33.png

Thank you so much sir
Thank you so much sir.