For the traffic lights the conditional format can only handle absolute references (e.g. $K$3).
You probably created the conditional format for the 1st row and then copied the format to the other rows.
With relative references (e.g. K3) Excel would automatically adjust the reference, but not so with absolute references.
That makes that the conditional format of he 2nd row etc keeps looking at the first row (i.c $K$3) and so the 1st row seems to work and the others don't.
To solve this I inserted an additional column holding the formula of the conditional format, but it's only showing the trafic light. That's an option you can set.
Added some additional comments in the attached sheet.
Will get back to you about to other things.
Bookmarks