Color rows according to a specific column and a specific cell

[Paul_Hossler]

What about the rest of the number, P5, P6, etc. that were not grey?

So

1. Check each cell in P3:AA37 (e.g. S5)

Using row 5 as example

P5 = 1, Q5 is blank so no color for P5

Q5 is blank, but R5 = 3 so no color for Q5 since 3 < AB5 - 1

R5 = 3, but S5 is blank so no color for R5

S5 is blank, but T5 = 2 so no color for S5 since 3 < AB5 - 1

T5 = 2, but U5 is blank so no color for T5


What do you mean accumlated?


These cells in row 1 are blank in your example. How do the factor in?

        If .Cells(1, 157).Value = 0 Then Exit Sub    '   no threshholds 15ti red e pyrviqt bonus ili kolonata s godinata 2023(EA) naprimer    
        T0 = .Cells(1, 117).Value 'DM KOLONA ILI SRAVNENIETO SPRQMO 1.12.2022    
        T1 = .Cells(1, 157).Value 'tezi 131, 132, 133, 134 ili EA, EB, EC, ED sa bonusite +30,+60,+90,+120 naprimer
        T2 = .Cells(1, 158).Value
        T3 = .Cells(1, 159).Value
        T4 = .Cells(1, 160).Value
        T5 = .Cells(1, 161).Value 'new color
        T6 = .Cells(1, 162).Value 'new color
        T7 = .Cells(1, 163).Value 'new color
        T8 = .Cells(1, 164).Value 'new color
        T9 = .Cells(1, 165).Value 'new color
        T10 = .Cells(1, 166).Value 'new color