MFish
Board Regular
- Joined
- May 9, 2019
- Messages
- 76
Hi,
I'd like to setup a conditional format that will change accordingly to certain Unique ID's.
<tbody>
</tbody>
The conditional format I'd like to run will highlight the cell range A1:D1 when the unique ID is found. In this case, the Unique ID is represented in column A:A. I'd like to know if there is a way to highlight every other unique ID with a different color, and/or, White to Grey to White to Grey. I'll be adding to this list and it auto-sorts on entry so the Unique ID will mend to the next one in line and will share the same color as it was beforehand, above.
All OAK 1 would be Grey
All OAK 2 would be White
All OAK 3 would be Grey
so on and so forth...
I'd like to setup a conditional format that will change accordingly to certain Unique ID's.
OAK 1 |
OAK 1 |
OAK 2 |
OAK 3 |
OAK 3 |
OAK 4 |
OAK 5 |
OAK 5 |
<tbody>
</tbody>
The conditional format I'd like to run will highlight the cell range A1:D1 when the unique ID is found. In this case, the Unique ID is represented in column A:A. I'd like to know if there is a way to highlight every other unique ID with a different color, and/or, White to Grey to White to Grey. I'll be adding to this list and it auto-sorts on entry so the Unique ID will mend to the next one in line and will share the same color as it was beforehand, above.
All OAK 1 would be Grey
All OAK 2 would be White
All OAK 3 would be Grey
so on and so forth...