Highlight MAX from cells not in range


I’m both an excel 2007 and excel 2016 user.

I want to highligth MAX if it is >0 from cells that are not in range. 

The cells are in the same row, but at different columns. For example, the cells of interest are C2, E2, G2, I2, M2, O2 and Q2. Each mentioned cell contain a positive or negative number.

I’m mostly interested for excel 2007 on how to highligth the cell/cells that contain the MAX of the cells mentioned above it is greater than zero.


Thank you



Leave a Reply

Your email address will not be published. Required fields are marked *