mark curtis
Registered User.
- Local time
- Today, 10:24
- Joined
- Oct 9, 2000
- Messages
- 457
Dear all,
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?
Thanks
Mark
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?
Thanks
Mark
