 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2006VB Macro In Excel 2003
I'm trying to make a vb macro for a sheet in excel. The sheet has inventory quantities in every other column. I would like for any quantity count under "10" to turn red. Anything "10" or greater to stay black. I'm not a programmer really. Could anyone suggest some syntax ideas? Thanks for any help! Look at Format|Conditional Formatting  SignatureKind regards, Niek Otten Microsoft MVP - Excel | I'm trying to make a vb macro for a sheet in excel. The sheet has | inventory quantities in every other column. I would like for any [quoted text clipped - 3 lines] | | Thanks for any help! > Look at Format|Conditional Formatting > [quoted text clipped - 11 lines] > | > | Thanks for any help! That's definately exemplifies what I'm going for, but is there a way to apply it to an entire column? Right now, even if I have a whole column selected, it only applies to the first cell. I have about 1000 inventory totals per sheet. Not sure I'd be able to do every one individually without weeping over losing that many days of my life! :) Thanks either way!! <even if I have a whole column selected, it only applies to the first cell> I'm not too sure. It may look like that in the dialog, but do check and see in the "normal" sheet view. Maybe more cells are involved than you thought. SignatureKind regards, Niek Otten Microsoft MVP - Excel | > Look at Format|Conditional Formatting | > [quoted text clipped - 19 lines] | | Thanks either way!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.