Ed,

A nice addition to what I'd already worked out. Thank you.

Why didn't I learn about this years ago? :-)

Pete



"ed" wrote:

On Apr 24, 9:48 am, Pete Rooney
wrote:
Good afternoon,

I could probably event code do this in VBA if I had more time, but is there
any way of using standard conditional formatting to say "colour this cell red
if the cell 10 coumns to the left contains a value" ?

Thanks in advance

Pete "17:30 deadline" Rooney

in cell A-1 conditional fomat "formula is" =sum(K1:K100)<0