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?