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