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 there another way to do this?