hi,
I have conditional formating on cell T17
condition is if sum of B17 to S17 is greater than 0.5 then the cell T17
should turn red (or specified color). I am using this equation =Sum(T17:S17)
Condition is working fine on T17.

I need to copy the same conditional formatting to
T18, T20, T21, T23, T24, T26, T27 etc.

I tried copy and paste special but it wont copy conditional formatting. Is
there another way to copy paste?