Hello

Is it possible to enter conditional formatting via the code rather than selecting each cell individually?

For example, for cell D3 I need to enter conditional formatting is formula of =isna(match(long,"worksheetname!$d$1:$d$1200,0))
And the same for k3, but searching column k instead
And for r3 etc

Then for cell G4 for example, instead of searching for "long" I need to search for "big" and this is then repeated four times over four different columns.

Any ideas? I have at least 60 X 4 occurrences to do..... Code would be far easier ...... If I knew how to do it!!!!