Hi!

Based on your description the grid is in the range B4:T18

You can apply CF to the entire grid with a single formula.

Select the entire grid range B4:T18
Goto FormatConditional Formatting

Now, when you enter your formula, cell B4 is the active cell. So enter the
formula that would apply to cell B4 and don't use absolute referencing.
Excel will automatically adjust the references in the formulas for the other
cells in the grid.

Of course, this all depends on what your formula is and would help if you
were to post more specific details. But in general, you should not have to
manually enter 600 formulas.

Biff

"Ian D. Weatherall" <Ian D. wrote in
message ...
Hi Folks,
I have a workbook with a list of associates and the hours they are to work
in a week.
I have a second workbook with the associates listed acrose the bottom
(b.....t), cells a4....a18 are numbered 15....1, which leaves me with a
grid.
I would like to change a cell colour or have the word goal appear above
each
associate depending on hours work.
Example:
Associate_1 is working 40 hours their goal would be to achieve 10 units,
therefore the #10 cell turns green. I can complete the conditional
formatting
formula to make this happen and it does work, but unless I am wrong I have
to
change the cell references for each cell, a cell at a time there for with
40
associates I have 600 cells to apply conditional formatting to.
Any thoughts on how I can make this easy?
I hope I have explained things clearly enough, the autofill function wont
change the cell references for me.
Thank you in advance,
Ian