Conditional formatting in a formula

[frankfranssen]

Hello,

I'm working on a file now where I have compare competitors.

Let say I have this information


A B C
1 name 1 10 20
2 name 2 20 10
3 name 3 10 20

Now I would like to hightlight cell a1 blue if cell b1 is the highest and red if c1 is the highest.

Is this even possible>

Please help!

Thanks in advance.

[alvin-chung]

Hi, try select A1:A3 and create 2 conditional formatting formulas:
1. =max(b1:c1)=b1 format with blue
2. =max(b1:c1)=c1 format with red

[FDibbins]

Hi and welcome to the forum

You can do this with 2 simple Conditional Formatting rules...

1. highlight the range you want to apply the conditional formatting to the ranger in column A)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =B1>C1 format fill BLUE

Repeat 3 and 4 with =C1>B1 format fill RED
What would you want to do if they are the same?

[frankfranssen]

Thank you both! This really helped me!

[alvin-chung]

Thank you for your feedback, you're welcome



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin