Forum Discussion
Rules and conditions specific on each line
In the screen shot you have absolute references; they need to be relative, in order for the conditional formatting in the lower rows to be using data from that respective row. So change $B$4 to B4 (or at least $B4); Similarly the reference to $C$3, although it's not clear to me why that refers to a different row. Of course, I don't know how you've arrayed the data for each employee.
In the screen shot you have absolute references; they need to be relative, in order for the conditional formatting in the lower rows to be using data from that respective row. So change $B$4 to B4 (or at least $B4); Similarly the reference to $C$3, although it's not clear to me why that refers to a different row. Of course, I don't know how you've arrayed the data for each employee.
I don't know why excel decided to put the cell I was clicking on in absolute...
Yes. That's the default way it works. I've been caught in that trap myself, which is why I knew to look there first.