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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Count & Format based on cell value
One way is to
Enter this in Cell A6 =IF('SET UP'!$C$2<(ROW()-5),"",ROW()-5) and copy down You can conditionally format the cells with condition <"" to format as you want. "JSnow" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Count & Format based on cell value
Why do you think you need to start a new thread?
You have suggestions at your other similar post. Gord Dibben MS Excel MVP On Fri, 16 Jan 2009 16:42:00 -0800, JSnow wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Count & Format based on cell value
Because, Gord, the other post yielded suggestions that didn't really apply to
my needs. Do you have any suggestions for my problem? "Gord Dibben" wrote: Why do you think you need to start a new thread? You have suggestions at your other similar post. Gord Dibben MS Excel MVP On Fri, 16 Jan 2009 16:42:00 -0800, JSnow wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Count & Format based on cell value
Sheeloo, thanks for the formula. I'm not familiar with the <"" (not equal
to blank?). I'm not sure how that would work. Would I refer it back to column A? If A<"" then condition? A-ha! Thank you! "Sheeloo" wrote: One way is to Enter this in Cell A6 =IF('SET UP'!$C$2<(ROW()-5),"",ROW()-5) and copy down You can conditionally format the cells with condition <"" to format as you want. "JSnow" wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Count & Format based on cell value
No help, just picking at you.
But if the other suggestion did not help you should stick with that thread and post the "it did not work" message. That way all can see what has been tried.. Gord On Fri, 16 Jan 2009 17:24:01 -0800, JSnow wrote: Because, Gord, the other post yielded suggestions that didn't really apply to my needs. Do you have any suggestions for my problem? "Gord Dibben" wrote: Why do you think you need to start a new thread? You have suggestions at your other similar post. Gord Dibben MS Excel MVP On Fri, 16 Jan 2009 16:42:00 -0800, JSnow wrote: 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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Count & Format based on cell value
You are right...it is not equal to blank
Just select Col A starting at A6 then enter the FORMULA IS in conditional formatting as =A6<"" Excel will adjust the address for other cells.. "JSnow" wrote: Sheeloo, thanks for the formula. I'm not familiar with the <"" (not equal to blank?). I'm not sure how that would work. Would I refer it back to column A? If A<"" then condition? A-ha! Thank you! "Sheeloo" wrote: One way is to Enter this in Cell A6 =IF('SET UP'!$C$2<(ROW()-5),"",ROW()-5) and copy down You can conditionally format the cells with condition <"" to format as you want. "JSnow" wrote: 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. |
Reply |
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 |