EXcel 2003 - Conditionally fomatting a column of cells if they contain a certain word

July 20th, 2011 - 11:13 am ET by kop202 | Report spam
I've trying to implement the advice in John Walkenbachs book
regarding formatting cells in a column in my spreadsheet if they
contain the word "PLANS"
Cannot get it to work
Can anyone please help?
email Follow the discussionReplies 1 replyReplies Make a reply

Replies

#1 isabelle
July 20th, 2011 - 11:40 am ET | Report spam
hi,

by exemple, select column A and doing the conditional formatting with this formula
=SEARCH("PLANS",$A1)>0


isabelle


Le 2011-07-20 11:13, kop202 a écrit :
I've trying to implement the advice in John Walkenbachs book
regarding formatting cells in a column in my spreadsheet if they
contain the word "PLANS"
Cannot get it to work
Can anyone please help?

Similar topics