Find products on a spreadsheet

Originally Posted by JieJenn

If your pages are sorted from low to high, you can use conditional formatting and pick formula option then enter =LEFT($C1,2) = "1,"

I thought that however if its only on Page1 then it wont have the comma in char position 2

Good call. Then AlKey's formula will works like a charm.

Originally Posted by pjwhitfield

I thought that however if its only on Page1 then it wont have the comma in char position 2