Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DEFAULT FORMAT PROBLEM IN EXCEL
Excel is autoformatting SKU/part numbers as dates. An application is creating Excel spreadsheets from a database and entering part numbers, some of which begin as 12-. For example 12-5901. A new spreadsheet is created but Excel automatically converts a cell with a number to Dec 1-01 (12/1/5901)...- dbvogt
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Colouring cells using VBA code?
I'm not sure what you mean. There are letters in the cells already due to if statements. I need to find code that will check each cell (or the entire range) and change the background depending on the letter. The following is what is in one typical cell of the schedule...- dbvogt
- Post #10
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Colouring cells using VBA code?
I need to get around the 3 conditions limit of Excel. Thread 68-223068 has lots of good code for this but is aimed at the user entering data into a cell and then the code colors the background. My cells already have formulas in them so I cannot use the code as written - the sheet is basically a...- dbvogt
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
