Hi,
I have been searching on google for some help on this issue but can only find helpful solutions about columns rather than rows. I am trying to use conditional formatting to highlight the first occurrence of a 0 in a row of numbers. I have multiple 0s and only want the first one (reading from left to right) to get highlighted. For example, below, the 0 after the 4 would get highlighted and not the ones following. Thanks!
7 7 4 0 0 0 0 0 0 0 0 0 0 0
Thanks!!
Bookmarks