Need invisible/shaded/highlighted cell

[Tom]

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

 

[swatsp0p]

Two options:

Use Format>Conditional 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 Special>Formats 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

 

[Dave Peterson]

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.