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

Two options:

Use FormatConditional Formatting.

In your first DATE cell, set the CF as:

Formula is: =OR($A3="Sat",$A3="SUN") click Format and set your Font
color to White (or whatever your background color is)

Copy this cell and Paste SpecialFormats to the rest of the cells in
your ranges of DATE and BILL DTE

--OR--

use an IF statement to enter an empty string in your cells:

=IF(OR($A3="Sat",$A3="Sun"),"",B2+1)

In either option, adjust the cell references to meet your needs.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=383650

Maybe you can use Format|Conditional formatting.

Select your range (B2:Cxxx) and with B2 the active cell
Format|conditional Formatting
formula is: =WEEKDAY(B2,2)5

And give it a white font on a white fill.



Tom wrote:

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

--

Dave Peterson