Thanks for that. it works spot on!

Cheears


"Duke Carey" wrote in message
...
sorry, make that

=$A$1= your value

"Ant" wrote:

I have a workbook where I would like to apply conditional formatting to
an
entire row, depending on the condition in the first column. I know how
to
apply the formatting to the cell in the first column but not the rest of
the
cells on that row. E.g. something like if the formatting of A1 = ??
then
also apply the same formatting to A2, A3 etc. If this can not be done
using
conditional formatting then is there another way?



Thanks for any help.