Is there a macro that will format unused rows or with no value in a given range. I have a sheet that I am using that some of the date is either added or deleted and would like to have a macro to do grey out unused rows. I am using this with a form control. any information would be helpful. thank you.
Last edited by tvonbehren; 11-17-2009 at 02:59 PM.
A macro could be written very easily, but perhaps easier still (and more automatic) would be simple conditional formatting.
Upload an example and we'll be able to tell for sure.
CC
Sure will try the formatting. Hand been working on sheet all day and brian was fried. totally spaced the formatting. If does not work the way I am looking for I will be back. thank you
Poor Brian, that sounds terrible.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks