Re: $$Excel-Macros$$ Highest No with Colour, Need Vba Code

2012-02-15 Thread Seraj Alam
@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

Re: $$Excel-Macros$$ Highest No with Colour, Need Vba Code

2012-02-15 Thread Seraj Alam
...@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

$$Excel-Macros$$ Highest no with colour

2012-02-10 Thread Veeru TOC
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* * * *

Re: $$Excel-Macros$$ Highest no with colour

2012-02-10 Thread PrIyAnKa
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

Re: $$Excel-Macros$$ Highest no with colour

2012-02-10 Thread Veeru TOC
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

Re: $$Excel-Macros$$ Highest no with colour

2012-02-10 Thread PrIyAnKa
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

Re: $$Excel-Macros$$ Highest no with colour

2012-02-10 Thread NOORAIN ANSARI
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

Re: $$Excel-Macros$$ Highest no with colour

2012-02-10 Thread Veeru TOC
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)

Re: $$Excel-Macros$$ Highest No with Colour, Need Vba Code

2012-02-10 Thread dguillett1
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