Thank you, it works but as a follow on...

How do I copy ONLY the colours of this particular column to several
other columns in the same row without copying the entire format of this
column.

e.g.

Condition 1 is green as a colour if it is true =ISNUMBER(C4)
but I also require cells B4,D4,E4 F4 too to become green if the above
condition is met though these cells do not contain the same data as C4,
etc

Thx
Regards
Gunj