Conditional Formatting Required based on other cell

[Khalid NGO]

Hello everyone,


I need to apply a CF but dont know what to do. Your help is required.

I have a data like this:


I have applied 1 CF in the TOTAL (TOP 1)

Now I need to apply same CF for Months Name. i.e. July-14 become GREEN.

Thanking you in anticipation.

Khalid

 

[Debraj]

Hi Khalid,

Select C6:E6, and apply Conditional Formatting > Formula as..
=MAX($C$17:$E$17)=C$17

 

[Khalid NGO]

Hi Khalid,

Select C6:E6, and apply Conditional Formatting > Formula as..
=MAX($C$17:$E$17)=C$17

Wow thats great...

Thanks Sir Debraj its working.
I need to know how its working. I understand till "MAX($C$17:$E$17)"

Can you please clarify about "=C17" (after max function)

 

[Debraj]

Hi Khalid,

Did you checked.. my "C$17" and your "C17" has little bit difference..

So when you apply this formula in C6, it will check accordingly C17 ad when in D6, it will check corresponding D17. due to that $ sign.

and Conditional Formatting check each cell in C6 to E6, and apply formatting according to C17 to E17..

for more detail check this..
http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/

 

[Khalid NGO]

Hi Sir Debraj,

Your clarification did great help for me to understand this.

Many thanks for the link and valued response.
Be Blessed.

Khalid