Microsoft Office Forums - View Single Post - [Solved] Any equiv. in Conditional Formatting???

Thread: [Solved] Any equiv. in Conditional Formatting???

View Single Post

Old

06-03-2012, 10:10 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

One way - the conditional formatting formula you could use to do this would be:

case insensitive
=COUNT(SEARCH({"teacher","tutor"},A1))=0

case sensitive
=COUNT(FIND({"Teacher","Tutor"},A1))=0

Last edited by Colin Legg; 06-03-2012 at 11:22 AM.

Reply With Quote