Using the IF function

[fluci]

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

 

[Jim Rech]

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
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?action=getinfo&userid=25896
| View this thread: http://www.excelforum.com/showthread.php?threadid=392916
|

 

[fluci]

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
(e-mail address removed)