Saxman,

You aren't clear on your requirements. I think you want a part of a row to
change color when M of that row is 1. If so:

1. Select the range to be conditionally formatted. Note the row that the
active (white) cell of your selection is.

2. Format - Conditional formatting - Formula is: =$M20=1 (in this case the
active cell was in row 20. Change formula as necessary).

3. Click "Format" and select the desired formatting.

4. OK your way out.


--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Saxman" wrote in message
...
If I had a cell in column M with the value 1, (in this case, cell M20),
could I highlight the cell colour in row 20 from columns A onward and any
other rows where the value 1 featured in column M?

TIA