On Wed, Feb 15, 2012 at 8:58 PM, Seraj Alam wrote:
>
>1. Select the whole table with data
>2. Choose the command Format | Conditional Formatting
>3. Choose Formula is
>4. Write in following formula: =MAX($A$1:$A$13)=A4 where A4 is the
>first cell with data
>5. Create the w
1. Select the whole table with data
2. Choose the command Format | Conditional Formatting
3. Choose Formula is
4. Write in following formula: =MAX($A$1:$A$13)=A4 where B4 is the first
cell with data
5. Create the wanted format
6. Close the form
On Fri, Feb 10, 2012 at 6:02 AM
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
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
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
