HI EXPERTS
I still could not solve the problem as it says
"""YOU CAN NOT USE REFERENCE TO OTHER WORKSHEET OR WORKBOOK FOR CONDITIONAL
FORMATTING CRITERION""".
I think it's beyond my capabilities now
hope to get good working suggestion!!

"MINAL ZUNKE" wrote:

I MANAGED TO SOLVE THE PROBLEM ON OWN.
THNX TO THOSE WHOSE TOOK TIME TO HELP ME OUT.!!!!!!!!!
CHEERS


"MINAL ZUNKE" wrote:

hi
experts

I am working on 2 worksheet. In worksheet 1, there is a column called
"Customer".
In worksheet 2, all the data related to customer is stored. I have
classified customer into 3 different types.
Class A (Blue), Class B(yellow), Class C(Pink)
No. of customers in every class is different and may get added on in future.
Class A Class B Class C
(Blue) (yellow) (pink)
Cus1 Cus1 Cus1
Cus2 Cus 2 Cus2
Cus3 Cus 3 Cus3
Cus4 Cus 4 Cus4
Cus5 Cus5 Cus5
Cus6 Cus6 Cus6
Cus7 Cus7
Cus8

I have developed a MS Access Query. The data in Customer column in Worksheet
1 gets filled in automatically as soon as I run a macro associated with the
query.

What I am after is as soon as data gets filled in, colour for that customer
should change based on the class that customer belongs to.
Now I have shown only 8, 7 and 6 no. of customer for class A, B and C
respectively. In future, as customer gets added on, the cell colour for that
class of customer should change automatically. I am basically after linking 2
worksheet to get this working.

Any suggestion will be greatly appreciated.
Thanking in anticipation