@googlegroups.com
*Subject:* $$Excel-Macros$$ Highest No with Colour, Need Vba Code
-- Dear Team
In my excel sheet i have below type of data i need Highest no with
Colour , pls send VBA Code
Normal data:
A
B
C
D
E
F
Total
10
18
25
26
*48*
70
197
25
48
...@gmail.com
*Sent:* Friday, February 10, 2012 6:13 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Highest No with Colour, Need Vba Code
-- Dear Team
In my excel sheet i have below type of data i need Highest no with
Colour , pls send VBA Code
Normal data
Dear Group
How to find Highest no with colour How its possible ,any formula..
--
Normal data:
A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 393
Req Data:-
A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386
*ThanksRegards*
* *
*
DO u need Highest one among the column or row?
and how 48 comes highest in E column ,kindly let us know
On Fri, Feb 10, 2012 at 4:51 PM, Veeru TOC veerub...@gmail.com wrote:
Dear Group
How to find Highest no with colour How its possible ,any
formula..
--
Normal data:
A B
Sorry . i need Column
Normal data:
A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 .
req data:-
A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386
req Dat:-
On Fri, Feb 10, 2012 at 5:01 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
DO u need Highest
U require by Row so go to Conditional formatting on Home tab with selecting
one row then go to TOp/Bottom Rules and click on TOp 10 items ,give value
of one and press ok
On Fri, Feb 10, 2012 at 5:07 PM, Veeru TOC veerub...@gmail.com wrote:
Sorry . i need Column
Normal data:
A B
Dear Veeru,
Use it
=A$2=MAX($A$2:$F$2)
=A$3=MAX($A$3:$F$3)
See attached sheet.
On Fri, Feb 10, 2012 at 5:07 PM, Veeru TOC veerub...@gmail.com wrote:
Sorry . i need Column
Normal data:
A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386.
req data:-
A B C D
Dear Sir,
I can't understand it,,,
in my excel sheet i have 1200 columns data there,suggest any vba code for
this highest no with colour
On Fri, Feb 10, 2012 at 5:50 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Veeru,
Use it
=A$2=MAX($A$2:$F$2)
Excel version_
How is color applied, manually___ or CF
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Veeru TOC
Sent: Friday, February 10, 2012 6:13 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Highest No with Colour, Need Vba Code