Need help with Conditional formatting. Thanks for helping :)

[pedie]

if in a cell any of the word or spelling in the word matches the word or spelling in A1 then i want the whole cell to be hilighted with RED...

for instance; if i write a word in a1 as "Add" and in b13 i have a word Addidas I want the whole cell to be hilighted....

Thanks for helping!!!!

pedie

 

[lenze]

In CF, Formula Is

=ISNUMBER(FIND($A$1,B13))

lenze

 

[pedie]

I am not sure where i did wrong I selected the area from B1 to F30 then click on conditional formating > new rule > use formula..... > entered the formula...and then > ok

I wrote few things which might match case not exat match...but it did not work...I am not sure where i did wrong..or my explaination was incorrect...


Pls ...lenze if you're there...look in to it again...


thanks alot!

 

[pedie]

bump

 

[meldoc]

Pedie

When you enter a Conditional Format, into a range like yours B1:F30, you have to set the formula to look at the first cell in the range.

So for Lenze's formula to work in your case, change it as below.

=ISNUMBER(FIND($A$1,B1))

Also see the video link, it is quite long but it will teach you just about, all you need to know about Conditional Formatting.

http://www.youtube.com/user/ExcelIsFun#p/search/6/9Dk1JoL_Pe4

 

[pedie]

Perfect...Brian...Lenze..thanks alot!!!
I didnt know what to do...thanks alot again and have a great weekend guys!!!