Using the IF function

F

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
 
J

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
|
 
F

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
[email protected]
 
Top