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

[ajmal pottekattil yoousuf]

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.

[#2 · Accepted solution]

@ajmal pottekattil yoousuf 

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

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

See attached.