If you want to copy this format down using the Format Painter, you
will have to amend the condition slightly to:

=$M2="Yes"

and then copy it to other rows.

Hope this helps.

Pete

On Apr 23, 9:34 am, bollard wrote:
Hi

I've now managed to get the first row in a worksheet to perform the
conditional formatting I want. But I'm having tourble trying to extend the
formatting to cover the whole spreadsheet. The Format Painter doesn't seem to
do the trick. I keep ending up with the whole spreadhseet turning green,
instead of only rows with "Yes" in one column.

Can anyone tell me how to extend the formatting, please?

At present it reads:
=$M$2="Yes"