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

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?
 
I

isabelle

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

Mail Merge Directory Conditional Page Break 0
Need Help with a VBA subroutine 0
Conditional Formatting Based On Formula Values 2
Conditional Formatting 1
Whole Column Conditional Formatting 2
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
conditional formatting: multiple conditions with min 0
Like an image map 2

Top