Using the IF function
 

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

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
|

aha
got it
conditional formating
also...
can someone help me write a macro?
i will send you the file and show you want i want done
i have no clue how to do macros :S
add me on msn



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