You'd need a macro. A formula can only return a result to the cell it is
in; it cannot do things like format cells, print, etc.

You might look at Format, conditional Formatting as another approach though.

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