Forum Discussion
Remove or (Highlighted ) the data based on the cell value
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.
you can highlight the row with the following conditional formatting formula:
=LEFT($B3,3)="KSA"
See attached.
you can highlight the row with the following conditional formatting formula:
=LEFT($B3,3)="KSA"
See attached.