Cell searching and retrieving

Select or highlight the cells you wish to check.
then at the menu, Format, conditional format,
select Cell Value Is, in blank box type test, choose format, pattern,,OK,
out
should work,,

"fluci" <fluci.1t81qb_1123128307.6915@excelforum-nospam.com> wrote in
message news:fluci.1t81qb_1123128307.6915@excelforum-nospam.com...
>
> Ok I have Cell A1 as Test
> Cells A2:A6 are random words
> Cells A7:A10 are Test
> And cells A11:A13 are random words again
>
> I want to search it so that When I type in a word in Cell A1 it will
> search through all of Column 1 and change the background colour of any
> other cells that have the same word
> is that possible?
>
>
> --
> fluci
> ------------------------------------------------------------------------
> fluci's Profile:
> http://www.excelforum.com/member.php...o&userid=25896
> View this thread: http://www.excelforum.com/showthread...hreadid=392780
>

Sorry, i think i missed your q,
You need to use the Formula Is Option and
in the box (with A2 the active cell) enter:
=A2=$A$1 ,, then format pattern..


"Jim May" <jmay@cox.net> wrote in message
news:VRnIe.6419$MZ6.2971@lakeread01...
> Select or highlight the cells you wish to check.
> then at the menu, Format, conditional format,
> select Cell Value Is, in blank box type test, choose format, pattern,,OK,
> out
> should work,,
>
> "fluci" <fluci.1t81qb_1123128307.6915@excelforum-nospam.com> wrote in
> message news:fluci.1t81qb_1123128307.6915@excelforum-nospam.com...
>>
>> Ok I have Cell A1 as Test
>> Cells A2:A6 are random words
>> Cells A7:A10 are Test
>> And cells A11:A13 are random words again
>>
>> I want to search it so that When I type in a word in Cell A1 it will
>> search through all of Column 1 and change the background colour of any
>> other cells that have the same word
>> is that possible?
>>
>>
>> --
>> fluci
>> ------------------------------------------------------------------------
>> fluci's Profile:
>> http://www.excelforum.com/member.php...o&userid=25896
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=392780
>>
>
>

will this automatically update whenever i change a cell say... A8?

ok sweet it does work!
thanks