Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 | |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |