Ken Johnson wrote:

Hi Saxman,

Select the whole sheet by clicking the empty square above row 1's label
and to the left of column 1's label.
Go Format|Conditional Formatting...
Use...

=$M1=1

That works fine, but only when I enter new data.

MY data is copied from another source and pasted as 'text special' in
columns A:J. All calculations are done in the remaining columns.

Pasting the data has no effect on the formatting if cells in the M
column contain 1, unless I type in 1 after the data has been pasted.
Probably because cell in the M column contains the following calculation.

=LEFT(H20,FIND("/",H20,1)-1)

(For cell M20).

It extracts the left digit from 1/12, i.e., finished 1st from 12 runners.

I can get over by typing 1 as above. Quicker than doing it by
highlighting rows etc.