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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Excel help 6
Conditional Formatting 1
Show a message if there are some duplicates 1
CONDITIONAL FORMATTING QUERY 0
Conditional formatting depending on sub string content i cell 4
Conditional Formatting Excel 2003 1
Excel If a Cell Contains a Certain Text (From Another Table) 0
Excel 2003 keeps adding conditional formatting by itself 2

Back
Top