Excel Conditional Formatting Top 1 exclude 0 Hello, I\'ve seen numerous posts an

Question

Excel Conditional Formatting Top 1 exclude 0

Hello,

I've seen numerous posts and answers online but no one seems to actually just answer this formula question:

I have a column using two conditional formats:

- One to highlight every other row for easier visibility

- One to highlight the maximum value in that column, but exclude cell values of 0

I can't just add another formatting to exclude those cells with that value because that messes up the every-other-row highlighting. I just need the working formula for the top 1 conditional formatting that excludes cell values of 0, so that the whole column isn't initially highlighted when everything is at 0

Thanks for help !!

Explanation / Answer

Hi..

Let's say you want to apply this to B4:B39.

The formula to use in conditional formatting would be.

=AND($B4=MAX($B$4:$B$39),$B4<>0).

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.