How do I create alternate colours which do not get effected when I use a filter a-z on them?

Hi,

I have used an excel template for my pipeline which has alternate 2x colours rows and that makes it easier to read between rows. I have added filters to the top of the columns to filter company names from A to Z, everytime I filter any column the colours of the rows move with the data/text in the cells.

for example, instead of:

blue

white

blue

white

I get a mixture of nonalternative coloured rows

blue

blue

white

white

I have googled a formula which worked well: =mod(row(),2)=1

but it does not let me highlight the coloured rows with any colour, and the biggest issue with that formula also, is that once I filter a column it adds another faded colour in few white rows

 

is there a simple formula or solution for this problem? I just want to filter company names without effecting the alternate colours or my highlighted cells. please help

By: Faissal

One thought on “How do I create alternate colours which do not get effected when I use a filter a-z on them?

  1. Faissal

    for those who are wondering about the formula I have used, I highlighted all the cells I am working with in the table and went to conditional formatting, chose a new rule then added that formula in the “use formula to determine which cells to format” arrow.

Leave a Reply

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