Forum Discussion
Solved
Rules and conditions specific on each line
Hello, I'm having issues with some conditions. I have employees that are younger than others in the company and I need to check when I have to control their work (juniors needing to be tested more...
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.
Oh right! Yes indeed it works better know. I don't know why excel decided to put the cell I was clicking on in absolute... Thank you very much, now it works!
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.