Notifications
Clear all
General Excel Questions & Answers
3
Posts
3
Users
0
Reactions
147
Views
Topic starter
Hello, I applied a conditional formatting for alternate rows for two specific columns in an excel table. The issue is that when it is filtered, the alternate rows do not show the formatting as alternating for the visible cells. Please assist. I have attached the file. Thanks
Posted : 26/09/2020 5:12 pm
It is working. The formula you have put in will colour the cells according to the row number - when you filter the row numbers dont change, you are just hiding the filter out rows
Posted : 26/09/2020 11:49 pm
Hello,
Just replace the ROW() part in the formula with SUBTOTAL(3,$E$1:$E1), depending on which cell (row) you want to be highlighted you might need to change the last number also. See attached file for reference.
Br,
Anders
Posted : 27/09/2020 2:24 am
