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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 11, 2017 at 12:04 PM
Related:
- Highlight only one column which has greater value
- Display two columns in data validation list but return only one - Guide
- Folder highlight - Download - Customization
- How to delete column in word - Guide
- Tweetdeck expand column - Guide
- Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum
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
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 11, 2017 at 12:04 PM
Aug 11, 2017 at 12:04 PM
awaismunir,
Thanks for the feedback.
I'm glad I helped.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Thanks for the feedback.
I'm glad I helped.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Aug 11, 2017 at 11:53 AM