Schedule Tracking

Copper Contributor

Hi, IScreenshot (2).png  need the cells to turn the color as follows

If D5=21 the 1st 21 cells(L5 to AF5) needs to be turned green

If G5=23 the AG6 to AH5 needs to be turned yellow

2 Replies


Use conditional formatting to highlight information



Hope I could help you with your project.



I know I don't know anything (Socrates)


Or perhaps like this: