Unfortunately I am using Excel 2003. Thanks for the input I'll give it a try.
--
abusymomforever


"Sheeloo" wrote:

Excel 2003 and earlier - You can have formats for a maximum of three
different conditions (four if you count the default format)...[Excel 2007
does not have this limitation.]


You can conditionally format B1 and then Paint the whole Col or Select the
whole column and then enter the formula for FORMULA is
=A1=1122
and then paint the format over other columns...

You need to use a macro if you want to color more than three(plus one)
different ways...


"abusymomforever" wrote:

A B J K
7 Date Store # Date Store #
8
9 01/01/2009 1122
10 01/02/2009 3666
11 01/03/2009 1121
12 01/03/2009 2586
13 01/03/2009 4558
14 01/14/2009 6687
15 01/15/2009 N/A
16 01/15/2009 3652
17 01/16/2009 Sam

If any cell in column b =1122 then FONT COLOR is a color off the font chart
that I choose and every row in the worksheet with that store # will be that
color. I need this for ever item listed in column "B" above. Each Store #
will have a different color.

Furthermore, I need that same function sent to several other worksheet in
the workbook. I think that is =b,etc. Again, I need this for every store #
in column "B" listed above. Can I do this as a column or do I have to start
at B1 or can I choose column "B"? If I have to choose a cell pic one in
column "B" that does not have a heading?

I know that to put the same information in cells "J" & "K" of the same
worksheet then that cell then format painter, correct?

If you have answers please help. I already have almost 800 rows that need
to be formated in column "B" to include in at least 6 other worksheets in the
workbook.
--
abusymomforever