Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Count & Format based on cell value
Hello again Gods of Excel. I'm using Excel 2003 for work, rows 1 - 5 are
used for header data. Here's what I'm struggling with this week: I need to use the value from sheet "SET UP" cell "C2" (which is a whole number, let's say 50) on all my other sheets (Jan - Dec) as some sort of counter. I'd like to accomplish two things on the Jan - Dec sheets: 1) starting w/ row 6 in column A, list 1 through whatever the number for C2 is on "SET UP" sheet. This will let the user know how much data entered each month. 2) format cells B6:K56 (row 6 + 50 in this example) with white background, grey border etc. Thanks in advance for any help. Note: this is a repost from earlier because I wasn't clear about what I needed. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count of Cells Based on Format | Excel Discussion (Misc queries) | |||
auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
Excel Auto-Format cell to email format | Excel Discussion (Misc queries) | |||
How to format a number cell to auto count 1 up on file open | Excel Worksheet Functions | |||
Auto-fill cell based on adjacent cell information.. | Excel Worksheet Functions |