Hi
Experts

I want to group 12 cities in 3 different groups named as class A, class b
and class c . three colour assigned to each class. when I enter a city
belonging to a certain class, cell colour should change according to that
class, so just by viewing colour I can guess the class of that particular
city.

Any fantastic suggestion greatly appreciated!!!

MINAL ZUNKE wrote:
Hi
Experts

I want to group 12 cities in 3 different groups named as class A, class b
and class c . three colour assigned to each class. when I enter a city
belonging to a certain class, cell colour should change according to that
class, so just by viewing colour I can guess the class of that particular
city.

Any fantastic suggestion greatly appreciated!!!



See help on conditional formatting.

gls858

You can use "Conditional Formatting".

You should start off by creating a data list of your cities in an
out-of-the-way area of your WS, say X1 to Z4.
X1 to X4 should be one class, and Y1:Y4 and Z1:Z4 the others.

Say you wish to format A1 to A20.
Select A1 to A20, with the focus of the selection in A1 (colored white).

Then, while all the cells are *still* selected,
<Format <Conditional Format
Change "CellValueIs" to "Formula Is",
And enter this formula in the second box:
=OR(A1=$X$1,A1=$X$2,A1=$X$3,A1=$X$4)

Then click on <Format, and choose your format.
Then <OK

Now, click <Add to enter your second condition,
Again change "CellValueIs" to "Formula Is",
And enter this formula in the second box:
=OR(A1=$Y$1,A1=$Y$2,A1=$Y$3,A1=$Y$4)
Then click on <Format, and choose your second format.
Then <OK

Repeat for the third and final condition with:
=OR(A1=$Z$1,A1=$Z$2,A1=$Z$3,A1=$Z$4)
Set your 3rd format, then <OK <OK.

You now have to make sure that your entries into Column A are *exactly* the
same as you entered them into your data list.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"MINAL ZUNKE" wrote in message
...
Hi
Experts

I want to group 12 cities in 3 different groups named as class A, class b
and class c . three colour assigned to each class. when I enter a city
belonging to a certain class, cell colour should change according to that
class, so just by viewing colour I can guess the class of that particular
city.

Any fantastic suggestion greatly appreciated!!!

hi
Rag Dyer

Thnx for you fantastic suggestion!! It is working Indeed
But one very small problem. The backgroud colour of all cells is changing to
the colour which is same as I have selected in CF1. Can you let me know how
to change the background colour to white. So that when I enter class A city
it changes to the colour I have selected for CF1 formating.

Thank you very much

"RagDyer" wrote:

You can use "Conditional Formatting".

You should start off by creating a data list of your cities in an
out-of-the-way area of your WS, say X1 to Z4.
X1 to X4 should be one class, and Y1:Y4 and Z1:Z4 the others.

Say you wish to format A1 to A20.
Select A1 to A20, with the focus of the selection in A1 (colored white).

Then, while all the cells are *still* selected,
<Format <Conditional Format
Change "CellValueIs" to "Formula Is",
And enter this formula in the second box:
=OR(A1=$X$1,A1=$X$2,A1=$X$3,A1=$X$4)

Then click on <Format, and choose your format.
Then <OK

Now, click <Add to enter your second condition,
Again change "CellValueIs" to "Formula Is",
And enter this formula in the second box:
=OR(A1=$Y$1,A1=$Y$2,A1=$Y$3,A1=$Y$4)
Then click on <Format, and choose your second format.
Then <OK

Repeat for the third and final condition with:
=OR(A1=$Z$1,A1=$Z$2,A1=$Z$3,A1=$Z$4)
Set your 3rd format, then <OK <OK.

You now have to make sure that your entries into Column A are *exactly* the
same as you entered them into your data list.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"MINAL ZUNKE" wrote in message
...
Hi
Experts

I want to group 12 cities in 3 different groups named as class A, class b
and class c . three colour assigned to each class. when I enter a city
belonging to a certain class, cell colour should change according to that
class, so just by viewing colour I can guess the class of that particular
city.

Any fantastic suggestion greatly appreciated!!!

Did you use different formats for each separate condition?

When you completed your last condition, all 3 conditions and formats should
be visible in the Conditional window.
Can you see the difference between them?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"MINAL ZUNKE" wrote in message
...
hi
Rag Dyer

Thnx for you fantastic suggestion!! It is working Indeed
But one very small problem. The backgroud colour of all cells is changing to
the colour which is same as I have selected in CF1. Can you let me know how
to change the background colour to white. So that when I enter class A city
it changes to the colour I have selected for CF1 formating.

Thank you very much

"RagDyer" wrote:

You can use "Conditional Formatting".

You should start off by creating a data list of your cities in an
out-of-the-way area of your WS, say X1 to Z4.
X1 to X4 should be one class, and Y1:Y4 and Z1:Z4 the others.

Say you wish to format A1 to A20.
Select A1 to A20, with the focus of the selection in A1 (colored white).

Then, while all the cells are *still* selected,
<Format <Conditional Format
Change "CellValueIs" to "Formula Is",
And enter this formula in the second box:
=OR(A1=$X$1,A1=$X$2,A1=$X$3,A1=$X$4)

Then click on <Format, and choose your format.
Then <OK

Now, click <Add to enter your second condition,
Again change "CellValueIs" to "Formula Is",
And enter this formula in the second box:
=OR(A1=$Y$1,A1=$Y$2,A1=$Y$3,A1=$Y$4)
Then click on <Format, and choose your second format.
Then <OK

Repeat for the third and final condition with:
=OR(A1=$Z$1,A1=$Z$2,A1=$Z$3,A1=$Z$4)
Set your 3rd format, then <OK <OK.

You now have to make sure that your entries into Column A are *exactly*
the
same as you entered them into your data list.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"MINAL ZUNKE" wrote in message
...
Hi
Experts

I want to group 12 cities in 3 different groups named as class A, class
b
and class c . three colour assigned to each class. when I enter a
city
belonging to a certain class, cell colour should change according to
that
class, so just by viewing colour I can guess the class of that
particular
city.

Any fantastic suggestion greatly appreciated!!!