Hello all,
I have a conditional formatting project I can't seem to figure out on my own. I have attached a sample workbook. Basically what I have done is effectively figured out how to format column A (names) with the coloring I want based on the criteria given.
What I would like to do is apply that same formula to the players corresponding two rows. Example, if the criteria is met for the first player "Russell Wilson", I would like to place the appropriate font color in cells B5:X5.
When I try to edit one of the rules, it changes all cells B5:X14, and I cannot seem to change each rule by itself. Any help would be greatly appreciated.
Bookmarks