How to find particular instances and make those lines highlighted

I want Excel to find any instance in which there is a 0 in one cell and then a value greater than 0 in the cell immediately to the right. Then, I want Excel to highlight the row in which that occurs.

For instance, if there is a row:
56 89 0 76 32
then it should be highlighted because there is a value greater than 0 (76) in the cell to the right of the 0.

How can I make this happen?

Thanks in advance for the help.

Originally Posted by girlofscience

I want Excel to find any instance in which there is a 0 in one cell and then a value greater than 0 in the cell immediately to the right. Then, I want Excel to highlight the row in which that occurs.

For instance, if there is a row:
56 89 0 76 32
then it should be highlighted because there is a value greater than 0 (76) in the cell to the right of the 0.

How can I make this happen?

Thanks in advance for the help.

You could index-match which column the zero is in and upon finding out that information you can determine if the cell immediately to the right is greater than zero by an if function. Use conditional formatting to have automatic highlights.

Hi,Girlofscience
Try this:-

Please Login or Register  to view this content.

Regards Mick