LinkBack URL
About LinkBacks
Hi
I am using the following to alternate colour on rows which is fine "=MOD(ROW(),2)=0" is there any way to maintain alternate row colours when heading filters are used?
Hi
I am using the following to alternate colour on rows which is fine "=MOD(ROW(),2)=0" is there any way to maintain alternate row colours when heading filters are used?
Hi,
Try using this Conditional Formatting formula instead:
=MOD(SUBTOTAL(3,$A$1:$A2),2)
Edit: This file shows it working (your formula in Sheet1, the above in Sheet2 - filter 'Age' to '12' to see the difference): CF colour alternate filtered rows.xls
Regards,
Aardigspook
If your problem is solved, please go to 'Thread Tools' on your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.
Last edited by Aardigspook; 07-29-2015 at 03:58 AM. Reason: Added example file
Hi thank you for the quick response.
The above formula works great, however it does depend on the 1st column being populated the whole length of the working sheet (A2:A70), not too big an issue though will just have to manage it.
Thanks
George
If you have a column which doesn't have any blanks, you can use that in the formula instead - just change $A$1:$A2 to $X$1:$X2 (where X is the column without blanks).
Regards,
Aardigspook
If your problem is solved, please go to 'Thread Tools' on your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.
Thanks Aardispook
Just the ticket, thanks again for the quick response.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks