excelishard987
New Member
- Joined
- Apr 2, 2019
- Messages
- 5
Hi, haven't been able to find an answer to this anywhere so here goes:
I want to shade alternate rows in a selection when a value in another column = 1.
So, for selection H11:T37, where the value in cell $D11 (through $D37) is 1, I want to shade alternate columns.
The reason for this is I have a filter on column D that hides rows there the value is not 1.
Any ideas? Thanks in advance.
I want to shade alternate rows in a selection when a value in another column = 1.
So, for selection H11:T37, where the value in cell $D11 (through $D37) is 1, I want to shade alternate columns.
The reason for this is I have a filter on column D that hides rows there the value is not 1.
Any ideas? Thanks in advance.