LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
MatthewTap
 
Posts: n/a
Default 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]
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
why does currency format change to number format? Cassie Excel Discussion (Misc queries) 3 March 18th 05 06:57 PM
Keep custom format in new worksheet Buddy Excel Discussion (Misc queries) 2 March 14th 05 10:03 AM
How to format a date to a different format Laura Excel Discussion (Misc queries) 1 March 5th 05 09:59 PM
Copying a conditional format Meaux Excel Worksheet Functions 2 November 29th 04 10:19 AM
When I select "format cells", the format dialog box does not disp. Andy S. Excel Worksheet Functions 2 November 23rd 04 03:49 AM


All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"