View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JSnow JSnow is offline
external usenet poster
 
Posts: 54
Default 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.