Hi I have an invoice that has a list of items on all the time and I want to have the font size for the columns qty, item, price, and total to change larger when there is a value in the qty field. I attached a sample. Wish conditional formatting would do it but I guess it can't mess with column and row widths.
Thanks in advance!
Last edited by trickyricky; 03-26-2011 at 09:39 AM.
Missing attachment....Originally Posted by trickyricky
haha sorry.. forgot to upload it
Conditional formatting can make text bold but it won't let you change font face or size. See attached for a solution for bold.
See second version for a VBA solution that does what you need.
Hey thanks! Works excellent!
Could you also show me the code to set it up as a Macro so I could click a button if I wanted to?
I appreciate it!
I don't think it will do any good to associate it with a button. It detects when the quantity is updated and modifies the format of that particular row; it doesn't reevaluate the entire list. You can see the code if you hit ALT-F11 and click on Sheet1.
For some reason it wasn't doing what I thought; here is a revision to the same code
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks