conditional formatting

[gambler844]

in condition one i put the following formula and shade it black and white
([AGO1]>=165 OR [AGO1] BETWEEN 0 AND 10) AND ([NCOURSE1] NOT LIKE "MT*" OR
[NCOURSE1] NOT LIKE "IT*")
I can't get the NOT LIKE part to work. I even change the not like to <> and
still no go. Sure would appreciate some help.
Thanks
ed

 

[John Spencer]

Try changing OR to AND between the Not Like clause

([AGO1]>=165 OR [AGO1] BETWEEN 0 AND 10)
AND ([NCOURSE1] NOT LIKE "MT*" AND
[NCOURSE1] NOT LIKE "IT*")

An alternative for this specific incident would be

([AGO1]>=165 OR [AGO1] BETWEEN 0 AND 10)
AND [NCOURSE1] NOT LIKE "[IM]T*"

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================