• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting

jskushawah

New Member
A B C D E F G H I

1 Haseeb 5701 9527 2704 2757 6968 6275 7799 2487

2 Nafees 4037 1372 5679 5343 8981 2612 4381 1184

3 Rahim 9751 4885 5790 8188 2445 1193 7138 5300

4 Karim 3574 8885 3462 1886 1975 9535 9985 5655

5 Navin 8781 9780 3591 4435 1470 5047 4528 2375


I want to highlight salesman in col A who made Maximum sale using CF, which formula should i use ??
 
Hi Kushawah ,


Can you see this file ?


http://speedy.sh/MyDnK/Kushawah-Book1.xlsx


Please note that in case the maximum value occurs more than once , only the name in the highest row will be highlighted.


Narayan
 
Thanks Narayan,


Actually I want to Highlight Salesman's Name who make Maximum sales.(i.e. Haseeb, Nafees, Rahim, Karim, Navin)
 
Hi jskushawah


Please follow below step which can probably solve your problem:


1. If your data has header row then in J2 cell insert the sum formula "=SUM(B2:I2)" and drag it below to the last row of your data.


2. Now goto the condtional formating option by pressing Ctrl+NHL for 2007 and select "Use Formula to determine which cells to format", here put the below formula and set highlighting color as per your choice.


"=INDIRECT("A" & MATCH(MAX(J:J),J:J,0))=A1"


Try the above steps, I think that will work for you as I tried the same on your sample data in my sheet.


Please let me know if still you face any issue in above.


Thanks & Regards,

Anupam Tiwari
 
Hi jskushawah,


I forgot to mention in above reply that when you put the above formula in conditional formating, first select the Column A and then use above formula in conditional formating.


Thanks & Regards,

Anupam Tiwari
 
Hi Jitendra,


Can you please try the below.. :)

Select column B, (column with Names).. apply Conditional Formatting formula as ..


Code:
=ISNUMBER(MATCH(MAX($C$1:$J$5),C1:J1,0))


Regards,

Deb
 
Back
Top