Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Highlight only one column which has greater value [Solved/Closed]

Report
-
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 -
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?


See more

2 replies

Answer 1 / 2
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 135
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
Report
Posts
1
Registration date
Friday August 11, 2017
Status
Member
Last seen
August 11, 2017
Yes it works... thanks a lot
Answer 2 / 2
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 135
awaismunir,

Thanks for the feedback.

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