Conditional Format not working properly

I have a sheet that calculates overtime. One cell, U11, shows my total OT. When accounting for my OT I can split it into three different categories in cells X11, Y11, & Z11.
What I'm trying to accomplish... I manually input totals into X, Y, & Z, when they equal U, I want X, Y, & Z to turn Green as a visual indicator that I've accounted for all my OT.

I can not get this to work. If I manually type in my OT in U11 the conditional formatting works, but if I let the formulas calculate my OT in U11, the conditional formatting does not work.

This worked for me previously when we tracked time in tenths, but we switched to minutes and after I've adjusted my sheet for this I can't get it to work.

I've attached the sheet that I'm working on. I've only been working on row 11 with the intent of copying everything down once I figure it out.

That worked partially... It changed the color of X11 only. I've checked three times, the CF is applied to X11:Z12??

I've edited the formula in post #2. I hadn't added the $s.

I agree with Mr Kennedy, those merged cells appear to serve no purpose so best to get rid of them and simply increase the row height to give the same visual feel (if that's why you've done it).

BSB

I agree with you. I should have done that this time around. I'm modifying someone else's sheet. I'll do that prior to copying everything down.
I have the same issue with your suggestion too, it works but only for X11.

That did the trick. How does making the cells have a absolute reference for the column make the difference?

Thank you both very much for your help. This has been killing me all evening.

Effectively you're applying the same formula to each column and if you don't absolute ref the columns then it will look at different columns in each, meaning:

Formula:

Please Login or Register  to view this content.

would become:

Formula:

Please Login or Register  to view this content.

and then:

Formula:

Please Login or Register  to view this content.

Hopefully you can see from that why your conditional formatting only worked in the first column without the $s.

BSB

So basically, even though I told the CF to to apply the formatting to X11:Z11, it keeps adjusting the formula for each column. Much like dragging a formula in a cell without an absolute reference. I just can't see it in the CF.

Exactly that.

BSB