Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello again Gods of Excel. 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) in as a counter. I'd like to accomplish two things on all the other sheets: 1) starting w/ row 6 in column A, list 1 through whatever the number for C2 is on "SET UP" sheet; 2) format cells B6:K56 (row 6 + 50 in this example) with white background, grey shading etc. So if I entered 50 on the SET UP sheet, all the other pages would have 50 lines formatted with 1-50 listed in column A. What if I changed that number to 30? Wouldn't the formatting remain for the rows labelled 31-50? Thanks in advance for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
over my head | Excel Discussion (Misc queries) | |||
Head to head | Excel Discussion (Misc queries) | |||
In over my head with calendar 8.0 | Excel Worksheet Functions | |||
Cant get my head around this one | Excel Worksheet Functions | |||
Over my head on this one... | Excel Worksheet Functions |