In Cells C1 through C18 add the format (Formula not cell value)

=C$18="Done"

and select your gray pattern.
--
HTH...

Jim Thomlinson


"sbarnum" wrote:

I was hoping to find a way to conditionally format using a single cell on a
row to format multiple cells in that row. So if I were on the "conditional
format dialog box", it might have a cell number before the "if"statement and
cell number before the format change. It would then allow if cell "C18"
were "equal to" "DONE" then cells C1:C18 would format to have a grey pattern.
Is ther currently a way to do this?