Highlight only one column which has greater value

Solved/Closed
Awais Munir - Updated on Aug 11, 2017 at 04:50 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 11, 2017 at 12:04 PM
Hello,

i am inputting numbers in column A , B , C and D so i wanna highlight only one column which has greater value from others. is there any possibility through conditional formatting?


2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 11, 2017 at 11:37 AM
Awais Munir, Good afternoon.

Try to do:

Select the range. Ex: A1:D20

Menu Conditional format
Using Formula

Type formula: =A1=LARGE($A1:$D1, 1)

Format Color as desired.
OK

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
awaismunir Posts 1 Registration date Friday August 11, 2017 Status Member Last seen August 11, 2017
Aug 11, 2017 at 11:53 AM
Yes it works... thanks a lot
0
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 11, 2017 at 12:04 PM
awaismunir,

Thanks for the feedback.

I'm glad I helped.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0