I am using 2007, and the range is 5 sheets of about 100 rows by 5 columns. I
need the conditional formatting of each A cell to apply only to the 4 cells
to the right. I can do it by copying the formatting row by row, but I don't
5 hours to devote to that. Any suggestions?

"T. Valko" wrote:

What version of Excel are you using and what is the *entire* range of cells
you want this to apply to?

--
Biff
Microsoft Excel MVP


"Brendan" wrote in message
...
Hi Guys,

I am trying to set up a time reporting worksheet to incorporate
conditional
formatting across a row based on the text value in the first column.

i.e.: cells A1:D1 are filled in orange when the formula (=A1="Coffee") is
true

I have had no problem with that portion of the process, but I can't figure
out how to apply it to more than one row at a time, much less the entire
worksheet. The only thing I have been able to do is get all of the
selected
cells to turn orange when the specific cell A1="Coffee." Is there a way
to
apply the conditional formatting rule of one set of cells to others?

Is there a way to incorporate conditional formatting formulas into a
standard "IF" formula?

Any help would be greatly appreciated