Conditional Formatting not giving true results

[The Shadowman]

Column BQ =INDEX($C:$C,AGGREGATE(15,6,ROW($C$31:$C$45)/($BX$31:$BX$45=LARGE($BX$31:$BX$45,ROWS(CC$26:CC26))),COUNTIF(BN$31:BN31,BN31)))
Column BV =RANK(LARGE($BN$31:$BN$45,ROWS($BV31:$BV$31)),$BN$31:$BN$45)
Column BX =SUM(D31:AG31)
Column BY =BX31-INDEX($D31:$AG31,AGGREGATE(14,6,COLUMN($D$31:$AG$31)-COLUMN($C$31)/($D$32:$AG$45>0),1))
Column CB =RANK(LARGE($BY$31:$BY$45,ROWS($CB$31:$CB31)),$BY$31:$BY$45)
Column CC =INDEX($C:$C,AGGREGATE(15,6,ROW($C$31:$C$45)/($BY$31:$BY$45=LARGE($BY$31:$BY$45,ROWS(CB$31:CB31))),COUNTIF(CB$31:CB31,CB31)))

Hi I thought all was well with this project, but I have discovered that the conditional formatting is not working correctly. It's not far out, but something is wrong giving the wrong result. The formulas above are, as far as I know, the one s that control it, but I am not sure.
I have uploaded a couple of pictures that will, I hope, help you see what's going wrong.
It's driving me mad so any help you can offer will be greatly appreciated.
Thanks
Robert

 

[The Shadowman]

Yes, each week the position of a player changes depending on his score. The arrows are supposed to reflect whether this change is up or down or staying level.

 

[6StringJazzer]

Yes, each week the position of a player changes depending on his score. The arrows are supposed to reflect whether this change is up or down or staying level.

That is the key sentence that was missing from your earlier posts.



The formula in BU31:BU45 is wrong. I'm not going to get into an analysis of why it's wrong but I corrected it.

Also your CF rule does not do quite what you wanted, but I couldn't determine that without knowing what the data meant. If someone moves down one position, it shows a yellow arrow to the right. I think you want a red arrow down. I have corrected the rule.

Dropbox - File Deleted - Simplify your life

www.dropbox.com

 

[The Shadowman]

Thank you so much. I’ve given the file a fair test and it seem to be working. I’m glad I was eventually able to get the message over to you.

Jeff, thanks for your patience, I’m really grateful.

 

[6StringJazzer]

I'm happy to help! Once I understood what the actual problem was it was pretty quick to fix.

I am going to leave my folder up but remove the file I gave you, assuming you now have a copy.

 

[The Shadowman]

Yes, it’s safely saved.

Thanks again

Robert