Hi All.
Got stuck with this one?
I have table from 1 to 8 groups?
In Group A Columns B5:L13, I have 3 teams on same points, LD, W and beat head to head?
If 3 team are on the same Points, LD, W and beat head to head? highlight yellow 1 come up M6:M8 come from dummy table sheet.
How to highlight in conditional formatting in red columns AF5:AL28 as you see in the file of rows 9,13 and 21?
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
Anyone know how to do it?
Try this formula in M5:
=IF(COUNTIFS($G$5:$G$13,G5,$H$5:$H$13,H5,$I$5:$I$13,I5,$K$5:$K$13,K5,$L$5:$L$13,L5,$L$5:$L$13,">0")=3,1,"")
Formula for CF in AH5:AL28
=IF(COUNTIF($M$5:$M$13,"1")=3,COUNTIF(OFFSET($C$4,MATCH(1,$M$5:$M$13,0),,3,1),$AH5)+COUNTIF(OFFSET($C$4,MATCH(1,$M$5:$M$13,0),,3,1),$AL5),0)=2
In 'Applies to' test box do thisFormula:
Please Login or Register to view this content.
Select 'New Rule' ---> 'Use a formula to determine which cells to format' ---> in 'Format values where this formula is true'Formula:Please Login or Register to view this content.
Dave
Hi
FlameRetired
Thank you for formula, only work C6:C8?
Does not C5:C13?
Phuocam
Thank you for formula,
I didn't need M5 formula as I already got automatic formula from Dummy sheet! Reason very difficult when head to head if work from table?
CF AH5:AL28? Work in Group A!
I try for group B, C and D? and it work by change number
M5:M13 to Z5:Z13 and C4 to P4 for group B
M5:M13 to M16:M24 and C4 to C15 for group C
M5:M13 to Z16:Z24 and C4 to P15 for group D
Thank you and all the best!
Will click solved once I completely other file by this weekend, if no problem?
Last edited by micope21; 05-09-2016 at 05:23 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks