Report

Highlight only one column which has greater value [Solved]

Ask a question Awais Munir - Last answered on Aug 11, 2017 at 12:04 PM by Mazzaropi
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 
Helpful
+0
plus moins
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
awaismunir 1Posts Friday August 11, 2017Registration date August 11, 2017 Last seen - Aug 11, 2017 at 11:53 AM
Yes it works... thanks a lot
Reply
Leave a comment
Helpful
+0
plus moins
awaismunir,

Thanks for the feedback.

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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!