Re: Counting unique No. by conditional formating

On 30/08/06, Alpesh B. Shah <alpesh9mtnl.net.in> wrote:
> Dear All members,
>
> I have data in five colums i.e through A to E
> Each column contains numeric data form Row 1 to Row
33.
> In each column is having some common no. appearing.
> I want to have conditional formulla by which I can give
colours to all the
> common nos.
>
>
>

It sounds like what you want is conditional formatting.

If you highlight the columns you want, and on the menu bar
choose
Format.... Conditional Formatting

>From there you define things like fonts/colours/borders
to be applied
when cells meet certain criteria (eg if value is between 1
and 100,
make the text red).


HTH,


-- 
AdamT
"A casual stroll through the lunatic asylum shows that
faith does not
prove anything." - Nietzsche

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

Put this condition as a "formula is" in the
conditional formatting for A!
=countif($A:$E,A1)>1
Then select a background colour that you want.
Go back and check ithe formula because Excel is almost
certain to have put
quotation marks round it.
Now copy A1 and "paste special" formats to A1:E33

On 30/01/07, AdamT <adwulfgmail.com> wrote:
>
> On 30/08/06, Alpesh B. Shah <alpesh9mtnl.net.in> wrote:
> > Dear All members,
> >
> > I have data in five colums i.e through A to E
> > Each column contains numeric data form Row 1 to
Row 33.
> > In each column is having some common no.
appearing.
> > I want to have conditional formulla by which I can
give colours to all
> the
> > common nos.
> >
> >
> >
>
> It sounds like what you want is conditional
formatting.
>
> If you highlight the columns you want, and on the menu
bar choose
> Format.... Conditional Formatting
>
> From there you define things like fonts/colours/borders
to be applied
> when cells meet certain criteria (eg if value is
between 1 and 100,
> make the text red).
>
>
> HTH,
>
>
> --
> AdamT
> "A casual stroll through the lunatic asylum shows
that faith does not
> prove anything." - Nietzsche
>
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software.  For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>



-- 
Regards

Adrian Fielden

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G