sometime type order have been make mistake that double key in, may i have a conditional format that if i key order no ABC1122 into A5 , it will check whether A1 to A4 and A6 to A100 have the same value, if it is true, its pattern become red.
please help, thanks.
Bookmarks