Conditional Formatting Question.

[Losguapos1]

So i have been racking my brain all day. I am trying to conditionally format the cells so that the team in overall first place is filled with gold, the team in second place is filled with silver and the team with third place is filled with bronze.

I have attached a sample of what I'm looking for.

Gold rows (1st place)
Team Evans
Team Pascuzzo

Silver rows (2nd place)
Team Bellmore
Team Mullins

Bronze rows (3rd place)
Team Gallagher
Team Rondinone

I want to use conditional formatting as the team in each place will change as more events are added.

Thanks in advance

Los

[sandy666]

Something like that? (two versions)

[Aardigspook]

If you want the whole row to be highlighted, select the whole range for each table (A4:I11 and A17:I22) then use this as the Conditional Formatting rule (Conditional Formatting > New Rule > Use a formula to determine which cells to format):

Please Login or Register  to view this content.

Attachment has this working.
Hope that helps.