Ask a question Report

Highlight only one column which has greater value [Solved]

Awais Munir - Aug 11, 2017 at 10:25 AM - Latest reply: Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen

- Aug 11, 2017 at 12:04 PM

Excel Ask a question Report

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?

Your reply

Reply to this topic

3 replies

Report Respond to Mazzaropi

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Aug 11, 2017 at 11:37 AM

Thank you

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 Respond to awaismunir

awaismunir 1 Posts Friday August 11, 2017Registration date August 11, 2017 Last seen - Aug 11, 2017 at 11:53 AM

Yes it works... thanks a lot

Report Respond to Mazzaropi

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Aug 11, 2017 at 12:04 PM

Thank you

awaismunir,

Thanks for the feedback.

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

Your reply

Reply to this topic

Ask a question