gt;> 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
>>
>>
>>
>> -- Dear Team
>>
>>
roups.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
&g
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
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 wrote:
> Dear Veeru,
>
> Use it
> =A$2=MAX($A$2:$F$2)
> =A$3=MAX($A$3:$F$3)
>
> See attached s
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 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 E F To
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 wrote:
>
>
> Sorry . i need Column
>
>
> Normal data:
>
> A B C D E F Tota
-- 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
96
48
91
78
386
.
req data:-
A
B
C
D
E
F
Total
10
18
25
26
*48*
70
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 wrote:
> DO u need Highest one among the column
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 wrote:
>
> Dear Group
>
>
> How to find Highest no with colour How its possible ,any
> formula..
> --
>
> Normal data:
>
> A B C D E F T
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
*Thanks&Regards*
* *
* **Veerendr
10 matches
Mail list logo