I need a formula to use in Conditional Formatting that will highlight the first cell in a row containing any value >0 and another formula that will highlight the last cell in a row containing any value >0. For example, my first row is C2:S2, where the first cell>0 is F2. I need a formula that will start looking in D2 and look until it reaches F2, where it will highlight that cell then move to row C3:S3. I am using Excel for Mac 2016.
Solved by V. U. in 30 mins