Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using a UDF in place of a cond. format, b/c I need 4, not three
I know this is an age old topic here, and I'm really hoping that I don't just
get referred to another web page [that type of help of course has its place and merits]. And if I had the time, I would have more fun going through docs and notes to find out how to do it, but time is not something I can barter. What I'm looking at is: I'm thinking along the lines of an example where I normally set the borders of my columns [except if it's the first row] in a cond. format via something like this: =AND((NOT(ISBLANK($A1))),(ROW()1)) But, if I need that space for a Conditional formatting, but I still want to do this. How would I go about doing this? With a UDF? I wouldn't know how to start. I can modify macros and run macros and such, but I don't know how I would convert something like this into a useable function, macro, anything. I would very much appreciate any help anyone can provide. Thanks! [a lot] |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
using a UDF in place of a cond. format, b/c I need 4, not three
You can't set borders with a UDF. CF can, but what do you mean but ... But,
if I need that space for a Conditional formatting, but I still want to do this ...? -- HTH RP (remove nothere from the email address if mailing direct) "MatthewTap" wrote in message ... I know this is an age old topic here, and I'm really hoping that I don't just get referred to another web page [that type of help of course has its place and merits]. And if I had the time, I would have more fun going through docs and notes to find out how to do it, but time is not something I can barter. What I'm looking at is: I'm thinking along the lines of an example where I normally set the borders of my columns [except if it's the first row] in a cond. format via something like this: =AND((NOT(ISBLANK($A1))),(ROW()1)) But, if I need that space for a Conditional formatting, but I still want to do this. How would I go about doing this? With a UDF? I wouldn't know how to start. I can modify macros and run macros and such, but I don't know how I would convert something like this into a useable function, macro, anything. I would very much appreciate any help anyone can provide. Thanks! [a lot] |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
using a UDF in place of a cond. format, b/c I need 4, not three
Translation...."I could do it myself, but would rather someone else put in the
time and did it for me." Not this cowboy. Gord Dibben Excel MVP On Mon, 12 Dec 2005 13:05:47 -0800, "MatthewTap" wrote: I would have more fun going through docs and notes to find out how to do it, but time is not something I can barter. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
using a UDF in place of a cond. format, b/c I need 4, not thre
Bob -- thank you. I did not know that a UDF couldn't control borders. I'm
still hoping an example of anything that could be in a CF but has been moved to a UDF [and I'm unclear on how that would run], because I just need to see one example... I've never seen one. #######################3 But, to Gord, thanks for the help. I was merely pointing out I don't have the time. Short of abstract concepts, finite number, whatever, most people on these boards can figure out anything on these boards given the time. and, given the way I know I learn, if I am shown a minimalist example, I learn more than just being shown a page with lots of random information on it and having to go through and find an example. That's the way I learn. I'm sorry that I don't learn the way you do -- maybe you consider it the only way any person ever should learn, and the rest of us shouldn't try to learn the way we know how to best. That would be really inefficient and ridiculous, and would cause those people to post for help that much more. Speaking of, this is a help discussion board. I'm not trying to flame, be mean, whatever. And people like you usually will hear this and just think "waaah" to me, but the fact is I can barely type; I've just been released from the hospital for a car wreck and three surgeries around my left arm and chest. So, yes, I need someone to show me and example, and I realize that may not happen... but I don't need you coming in here and letting everyone know that you never had anyone show you anything in your entire life. If you have anything to help, please post. If you don't, thanks for making my recovery that much harder. I'll never get people like you. I could really use the help, so if you get down and want to help someone, I would be more than pleased. If you'd rather go with the thought that the knowledge of Excel is a zero sum game, then don't help me. I'll just go to one of these pages, print them out, and have the nurse read them to me while the glass in my eye is continually being worked out. http://www.mvps.org/dmcritchie/excel...htm#HasFormula http://www.mcgimpsey.com/excel/udfs/sumbold.html http://www.mvps.org/dmcritchie/excel/getstarted.htm "Gord Dibben" wrote: Translation...."I could do it myself, but would rather someone else put in the time and did it for me." Not this cowboy. Gord Dibben Excel MVP On Mon, 12 Dec 2005 13:05:47 -0800, "MatthewTap" wrote: I would have more fun going through docs and notes to find out how to do it, but time is not something I can barter. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
using a UDF in place of a cond. format, b/c I need 4, not thre
Matthew
Sorry for your plight. I agree these are help groups and help is usually given unconditionally but your "time is not something I can barter" struck a nerve. Gord On Mon, 12 Dec 2005 14:05:04 -0800, "MatthewTap" wrote: Bob -- thank you. I did not know that a UDF couldn't control borders. I'm still hoping an example of anything that could be in a CF but has been moved to a UDF [and I'm unclear on how that would run], because I just need to see one example... I've never seen one. #######################3 But, to Gord, thanks for the help. I was merely pointing out I don't have the time. Short of abstract concepts, finite number, whatever, most people on these boards can figure out anything on these boards given the time. and, given the way I know I learn, if I am shown a minimalist example, I learn more than just being shown a page with lots of random information on it and having to go through and find an example. That's the way I learn. I'm sorry that I don't learn the way you do -- maybe you consider it the only way any person ever should learn, and the rest of us shouldn't try to learn the way we know how to best. That would be really inefficient and ridiculous, and would cause those people to post for help that much more. Speaking of, this is a help discussion board. I'm not trying to flame, be mean, whatever. And people like you usually will hear this and just think "waaah" to me, but the fact is I can barely type; I've just been released from the hospital for a car wreck and three surgeries around my left arm and chest. So, yes, I need someone to show me and example, and I realize that may not happen... but I don't need you coming in here and letting everyone know that you never had anyone show you anything in your entire life. If you have anything to help, please post. If you don't, thanks for making my recovery that much harder. I'll never get people like you. I could really use the help, so if you get down and want to help someone, I would be more than pleased. If you'd rather go with the thought that the knowledge of Excel is a zero sum game, then don't help me. I'll just go to one of these pages, print them out, and have the nurse read them to me while the glass in my eye is continually being worked out. http://www.mvps.org/dmcritchie/excel...htm#HasFormula http://www.mcgimpsey.com/excel/udfs/sumbold.html http://www.mvps.org/dmcritchie/excel/getstarted.htm "Gord Dibben" wrote: Translation...."I could do it myself, but would rather someone else put in the time and did it for me." Not this cowboy. Gord Dibben Excel MVP On Mon, 12 Dec 2005 13:05:47 -0800, "MatthewTap" wrote: I would have more fun going through docs and notes to find out how to do it, but time is not something I can barter. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
using a UDF in place of a cond. format, b/c I need 4, not thre
If something strikes a nerve, don't answer it.
but if someone can't say "I'm swamped and need help" without Lord MVP Gord coming and saying "look it up yourself", what good is this place? Everyone posting here has to balance time versus what they can look up, and since everything ever posted here is something that could, in fact, be looked up, if you're going to tell me I shouldn't have the right to post here, you should tell that to everyone. Everyone here is posting because they do not have the time to look up the solution... everyone. We're all hoping when we post here that someone in the community will help us out so that we can continue to build whatever we are building, and learn by doing it, and then hopefully be able to help others in the future. And of course everyone is busy... I don't know anyone in the computer field that isn't. Again, that's what these boards are for. It's not like the people, or me if you think so low of me because I didn't phrase something correctly, posts something here and then goes off to play StarCraft -- no, we're working and wouldn't mind some assistance. Your comment guaranteed that I wouldn't get help on my answer, so thanks very much. Please go post on someone else that the answer is simple and they should just take the time to look it up -- I'm perfectly fine without your interference. "Gord Dibben" wrote: Matthew Sorry for your plight. I agree these are help groups and help is usually given unconditionally but your "time is not something I can barter" struck a nerve. Gord On Mon, 12 Dec 2005 14:05:04 -0800, "MatthewTap" wrote: Bob -- thank you. I did not know that a UDF couldn't control borders. I'm still hoping an example of anything that could be in a CF but has been moved to a UDF [and I'm unclear on how that would run], because I just need to see one example... I've never seen one. #######################3 But, to Gord, thanks for the help. I was merely pointing out I don't have the time. Short of abstract concepts, finite number, whatever, most people on these boards can figure out anything on these boards given the time. and, given the way I know I learn, if I am shown a minimalist example, I learn more than just being shown a page with lots of random information on it and having to go through and find an example. That's the way I learn. I'm sorry that I don't learn the way you do -- maybe you consider it the only way any person ever should learn, and the rest of us shouldn't try to learn the way we know how to best. That would be really inefficient and ridiculous, and would cause those people to post for help that much more. Speaking of, this is a help discussion board. I'm not trying to flame, be mean, whatever. And people like you usually will hear this and just think "waaah" to me, but the fact is I can barely type; I've just been released from the hospital for a car wreck and three surgeries around my left arm and chest. So, yes, I need someone to show me and example, and I realize that may not happen... but I don't need you coming in here and letting everyone know that you never had anyone show you anything in your entire life. If you have anything to help, please post. If you don't, thanks for making my recovery that much harder. I'll never get people like you. I could really use the help, so if you get down and want to help someone, I would be more than pleased. If you'd rather go with the thought that the knowledge of Excel is a zero sum game, then don't help me. I'll just go to one of these pages, print them out, and have the nurse read them to me while the glass in my eye is continually being worked out. http://www.mvps.org/dmcritchie/excel...htm#HasFormula http://www.mcgimpsey.com/excel/udfs/sumbold.html http://www.mvps.org/dmcritchie/excel/getstarted.htm "Gord Dibben" wrote: Translation...."I could do it myself, but would rather someone else put in the time and did it for me." Not this cowboy. Gord Dibben Excel MVP On Mon, 12 Dec 2005 13:05:47 -0800, "MatthewTap" wrote: I would have more fun going through docs and notes to find out how to do it, but time is not something I can barter. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions | |||
When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions |