Ok I have A1 as test, A2:9 as blah, A10 as test and A11:A20 as blah
so it looks like this

test
blah
blah
blah
blah
blah
blah
blah
blah
blah
test
blah
blah
blah
blah
blah
blah
blah
blah
blah
blah

What I want to do is make A1 so that IF(A1=???Any of cells A2:20???,
then it becomes the same format as A1
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=392916