View Single Post
 
Old 05-25-2023, 08:41 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

You're going to have to adjust the conditional formatting.
It's the conditional formatting (CF) which currently gives a purple colour and applies to the whole range I7:BL33.
1. You'll need to reduce the applies to range to the first section of rows and adjust its colour fill, then
2. duplicate this CF, then adjust the range it applies to, and its fill colour.
3. for each different colour you want.

Not something I'd look forward to doing but it's not that hard.
Reply With Quote