Highlight only one column which has greater value
Solved/Closed
Awais Munir
-
Updated on Aug 11, 2017 at 04:50 PM
Mazzaropi
Mazzaropi
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Related:
- Highlight only one column which has greater value
- Highlight cells in column based on another column ✓ - Forum - Excel
- Highlight cells if greater than another column ✓ - Forum - Office Software
- Highlight cells that contain text from another column ✓ - Forum - Excel
- Excel partial match two columns - Guide
- How to change story highlights from close friends to everyone - Forum - Instagram
2 replies
Mazzaropi
Aug 11, 2017 at 11:37 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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
Aug 11, 2017 at 12:04 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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