Conditional Format - Sum dynamic range

[Skovgaard]

Hi Experts,

Can anyone tell me why below conditional format wont work and how to re-write?

I'm trying to highlight a cell in a pivot, if the sum of all cells to the right is zero.
I've tried to fix the last column, but then the last cell also gets the format, hence the sum of the blanks (outside the pivot) to the right, is zero.

/Skovgaard

 

[Peter_SSs]

What about?

=AND(SUM(N5:$CC5)=0,COUNT(N5:$CC5)>0)

 

[Skovgaard]

What about?

=AND(SUM(N5:$CC5)=0,COUNT(N5:$CC5)>0)

Thanks Peter, that worked

/Skovgaard

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.

 

[smozgur]

Thanks Peter, that worked

/Skovgaard

The marked solution has been changed accordingly.

@Skovgaard: In your future questions, please mark the post as the solution that answered your question instead of your feedback message as it will help future readers. No further action is required for this thread.