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"