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

  • Thread starter Thread starter kop202
  • Start date Start date
K

kop202

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?
 
hi,

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