Hi i want to show , different color for each group i have 2003 excel
can i use conditional formatting?


123 green
123 green
456 red
456 red
888 green
999 red
999 red

I assume that your data is in Column-A. Place the cursor in A1 cell
and press Cntrl+Spacebar. Now the total column-A will be getting
selected and the A1 will be the Active cell (Active Cell will have a
white Background after selection).

Format>>Conditional Formatting>>Condition 1>>Formula Is>>
=COUNTIF(A:A,A1)=1
Then Click the Format command button and choose your desired Font and
Pattern colour.
This will highlight the Non Duplicate Values.

Press Add Command button to add another Condition
Condition 2>>Formula Is>>
=COUNTIF(A:A,A1)>1
Then Click the Format command button and choose your desired Font and
Pattern colour.
This will highlight the Duplicate Values.

Click Ok…

Hope it’s clear to you.

-----------------------
Ms-Exl-Learner
-----------------------


On Jul 28, 7:21*am, whatever <burningthemidnite...@gmail.com> wrote:
> Hi i want to show , different color for each group i have 2003 excel
> can i use conditional formatting?
>
> 123 green
> 123 green
> 456 red
> 456 red
> 888 green
> 999 red
> 999 red

Hi thanks your solution ..i am aware of..it is not what i asked..
your solution ...does this

> > 123 green
> > 123 green
> > 456 green
> > 456 green

this is what i want i challenge anyone to do this in a conditional
format formula..? any gurus out there..?

> > 123 green
> > 123 green
> > 456 red
> > 456 red
> > 888 green
> > 999 red
> > 999 red- Hide quoted text -
>
> - Show quoted text -

"whatever" <(E-Mail Removed)> wrote in message
news:18def726-8ca1-4d8c-afa5-(E-Mail Removed)...
> Hi i want to show , different color for each group i have 2003 excel
> can i use conditional formatting?
>
>
> 123 green
> 123 green
> 456 red
> 456 red
> 888 green
> 999 red
> 999 red

Hello.

Try this:
A1 green, but conditionally red using the formula
=MOD(SUM(--(A1:A10<>A2:A11)),2)

The color sequence will start from the bottom,
but maybe you can tweak the formula so that it starts from the top, if desired.
I could not.

Hans T.

"Hans Terkelsen" <dk> wrote in message news:4c4fee71$0$276$(E-Mail Removed)...
>
> "whatever" <(E-Mail Removed)> wrote in message
> news:18def726-8ca1-4d8c-afa5-(E-Mail Removed)...
>> Hi i want to show , different color for each group i have 2003 excel
>> can i use conditional formatting?
>>
>>
>> 123 green
>> 123 green
>> 456 red
>> 456 red
>> 888 green
>> 999 red
>> 999 red
>
> Hello.
>
> Try this:
> A1 green, but conditionally red using the formula
> =MOD(SUM(--(A1:A10<>A2:A11)),2)
>
> The color sequence will start from the bottom,
> but maybe you can tweak the formula so that it starts from the top, if desired.
> I could not.
>
> Hans T.
>

Hi again, forgot to mention that the format should be copied down,
using the format painter. Hans T.