Select cells C1:C18

go to Conditional Format

Formula is: =$C$18="done"

Set pattern.
================
Record a macro while you do this and than you can automate it...
--
steveB

Remove "AYN" from email to respond
"sbarnum" wrote in message
...
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?