Highlight alternate unique values in a filtered column

Hello everybody,

I have a (True & False) helper in column G4:G26 to apply a conditional formatting rule that highlight alternate unique values on data A4:E26. But is does not correctly highlight alternate unique values after applying a filter in column E (after deselect zeros). The headers are in row 3

True False Formula in G4 (Typed "FALSE" in G3)
=IF(A4=A3,G3,NOT(G3))

Conditional Formatting Formula
=$G4

Any ideas of how to make this work after filtering the data ? Also attached is a sample data to better display the situation.

Thanks.

Try this in G4 and drag down...

=IF(E4=0,IF(A4=A3,G3,FALSE),IF(A4=A3,NOT(G3),TRUE))

if I've understood, one option might be:

Formula:

Please Login or Register  to view this content.

above assumes you may choose to filter by one or more fields at any point in time, and that the banding should alternate relative to visible values in Col A at all times

Croweater - The formula provided does not highlight unique values in column A and I think is because is tied to the zeros in column E. It should allow for any other filtered amount.

XLent - It worked perfectly and both ways with and without filtering data.

Really appreciate both for your help!