this is the bit thats confussing me. When i chose conditional format by formula and input (=LEFT(H4,FIND("/",H4)-1)+RIGHT(H4,LEN(H4)-FIND("/",H4))>$D4) as the criteria , when i change which cells it applies to ( columns H:AL) all cells are looking to H4 for the result?