SOLVED

Remove or (Highlighted ) the data based on the cell value

Frequent Contributor

Based on the code of the item should be removed or highlighted

 

Here the item code is started in KSA.

 we needed to highlight or remove the row if the item code is started in KSA.

 

1 Reply
best response confirmed by ajmal pottekattil yoousuf (Frequent Contributor)
Solution

@ajmal pottekattil yoousuf 

you can highlight the row with the following conditional formatting formula:

 

=LEFT($B3,3)="KSA"

 

See attached.