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" 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" wrote in
message ...

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?


--
fluci
------------------------------------------------------------------------
fluci's Profile: http://www.excelforum.com/member.php...o&userid=25896
View this thread: http://www.excelforum.com/showthread...hreadid=392780

ok sweet it does work!
thanks


--
fluci
------------------------------------------------------------------------
fluci's Profile: http://www.excelforum.com/member.php...o&userid=25896
View this thread: http://www.excelforum.com/showthread...hreadid=392780