Hi all,

I have a list of data like this (eg A3 to A8)
Beach Cove Field Engineer
Beach Cove Transport
Beach Cove Admin
Greenfield Field Engineer
Greenfield Transport
Greenfield Admin

I then have a cell (A1) which has the following location: 'Greenfield'

What I would like to do is conditionally format all of the data based on the word in A1 (so that this can be changed easily). So say A1=Greenfield, I would like any cell which does NOT contain 'Greenfield" to be coloured red.

The reason for having cell A1 is so that the location can be easily changed, without editing the conditional formatting rule.

I might be missing something, but I can't seem to make this happen. Any ideas would be much appreciated!