Conditional Format Expression

D Willett
SilverLounger
Posts: 1728
Joined: 25 Jan 2010, 08:34
Location: Stoke on Trent - Staffordshire - England

Conditional Format Expression

Post by D Willett »

Just wondering if I can expand the expression [JOB_CAT] Like "*DROP*" to [JOB_CAT] Like "*DROP*" or "*D/IN*" adding the extra category.
It seems some folk here can't follow instruction :-(

I am at the maximum of three so can't add any more.

Happy New Year
Cheers ...

Dave.

User avatar
HansV
Administrator
Posts: 78545
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditional Format Expression

Post by HansV »

You could use

[JOB_CAT] Like "*DROP*" OR [JOB_CAT] Like "*D/IN*"

(Happy New Year to you too!)
Best wishes,
Hans

D Willett
SilverLounger
Posts: 1728
Joined: 25 Jan 2010, 08:34
Location: Stoke on Trent - Staffordshire - England

Re: Conditional Format Expression

Post by D Willett »

lol ... I was close !!

Cheers Hans
Cheers ...

Dave.