Schedule Tracking

[Prabhakaran_336]

Hi, I  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]

@Prabhakaran_336 

Use conditional formatting to highlight information

Hope I could help you with your project.

NikolinoDE

I know I don't know anything (Socrates)

[#3]

@Prabhakaran_336 

Or perhaps like this: