LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Tom
 
Posts: n/a
Default Need invisible/shaded/highlighted cell

I'm thinking what I would like to do can *probably* be done in VBA, but I'd like
to use the formula in the cell. If it can be done.

I have three columns:

DOW DATE BILL DTE
--- -------- --------
Wed 02/01/06 02/03/06
Thu 02/02/06 02/06/06
Fri 02/03/06 02/07/06
Sat 02/04/06 02/06/06
Sun 02/05/06 02/07/06
Mon 02/06/06 02/08/06
Tue 02/07/06 02/09/06
Wed 02/08/06 02/10/06
. .
. .

The date col contains a formula to add 1 to the cell above. The day of week col
uses the date from the date column. And the bill date col adds 4 days to the
date col if it falls on a "Thu" or "Fri", otherwise it adds 2 days to the date
col.

I'm trying to make it easier for others to read. (Some are having a real
problem with it.) I'd *prefer* to hide dates falling on (starting from) a
weekend. If I can't hide the value, can I shade it? Or decrease the font size?
I'm just looking for a way to make the "Sat" & "Sun" rows...*not* stand out.

I would *LIKE* to see my data like this:

DOW DATE BILL DTE
--- -------- --------
Wed 02/01/06 02/03/06
Thu 02/02/06 02/06/06
Fri 02/03/06 02/07/06
Sat
Sun
Mon 02/06/06 02/08/06
Tue 02/07/06 02/09/06
Wed 02/08/06 02/10/06
. .
. .

But I could settle for this:

DOW DATE BILL DTE
--- -------- --------
Wed 02/01/06 02/03/06
Thu 02/02/06 02/06/06
Fri 02/03/06 02/07/06
Sat 02/04/06
Sun 02/05/06
Mon 02/06/06 02/08/06
Tue 02/07/06 02/09/06
Wed 02/08/06 02/10/06
. .
. .

Or highlighted with shading?

Anyone have any ideas/thoughts?

Thanks in advance,

Tom

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Cell Change Color - Need Help alani New Users to Excel 3 June 29th 05 03:50 PM
Pasting Word table cell with paragraph markers into single Excel c Steve Excel Discussion (Misc queries) 1 June 16th 05 11:26 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"