Lady of the Lake, Widow of the Web and PAT to me you are the Female of the Forum!

[mark curtis]

I need to check the content of a cell against the following and if it matches any of them them change the cell colour. I want to build

if cell = "In('£0 0#','< MANDATORY >','<Mandatory>','Missing','tbc','tba','n/a','missing')" then
colour it.

The code does not seem to recognise < MANDATORY > or <Mandatory>, which are both default values from the database. Is my SQL syntax wrong?

 

[Mile-O]

Isn't that question here?

 

[mark curtis]

sorry all