EXCEL 2003: Apply Conditional Formatting to COLUMNS

Where ROW=DAY, want COLUMS to SHADE therefore it is not "cell specific" as to
THAT cell's content, but I want that column's cells to shade based upon a
specific cells value or formula.

ROW 2
A2 B2
04-01 04-02
hard =A1+1

ROW 3
=IF(WEEKDAY(B2)=2,"MO",IF(WEEKDAY(B2)=3,"TU",IF(WEEKDAY(B2)=4,"WE",IF(WEEKDAY(B2)=5,"TH",IF(WEEKDAY(B2)=6,"FR",IF(WEEKDAY(B2)=7,"SA",IF(WEEKDAY(B2)=1,"SU","")))))))

I want ColB to shade if result of above formula is X day (Monday).

Hi!

Can't understand what it is you want to conditional
format. Maybe post back with a more descriptive
explanation.

In the mean time, you can shorten that formula to:

=LEFT(TEXT(B2,"ddd"),2)

If you need to test for an empty cell:

=IF(B2="","",LEFT(TEXT(B2,"ddd"),2))

Biff

>-----Original Message-----
>Where ROW=DAY, want COLUMS to SHADE therefore it is
not "cell specific" as to
>THAT cell's content, but I want that column's cells to
shade based upon a
>specific cells value or formula.
>
>ROW 2
> A2 B2
> 04-01 04-02
> hard =A1+1
>
>ROW 3
>=IF(WEEKDAY(B2)=2,"MO",IF(WEEKDAY(B2)=3,"TU",IF(WEEKDAY
(B2)=4,"WE",IF(WEEKDAY(B2)=5,"TH",IF(WEEKDAY(B2)=6,"FR",IF
(WEEKDAY(B2)=7,"SA",IF(WEEKDAY(B2)=1,"SU","")))))))
>
>I want ColB to shade if result of above formula is X day
(Monday).
>.
>

Select all colums to format

In Format|Conditional Formating

Change "Cell Value is" to "Formula is"

and enter =WEEKDAY($A1)=2

Lance

"HWDFWXCLGuru" wrote:

> Where ROW=DAY, want COLUMS to SHADE therefore it is not "cell specific" as to
> THAT cell's content, but I want that column's cells to shade based upon a
> specific cells value or formula.
>
> ROW 2
> A2 B2
> 04-01 04-02
> hard =A1+1
>
> ROW 3
> =IF(WEEKDAY(B2)=2,"MO",IF(WEEKDAY(B2)=3,"TU",IF(WEEKDAY(B2)=4,"WE",IF(WEEKDAY(B2)=5,"TH",IF(WEEKDAY(B2)=6,"FR",IF(WEEKDAY(B2)=7,"SA",IF(WEEKDAY(B2)=1,"SU","")))))))
>
> I want ColB to shade if result of above formula is X day (Monday).

ThankX "Biff" ~

Where DATE and/or DAY = MO, I want to have those columns shaded.

Each month when I generate this form, the columns for MO would change

DAILY REPORTS RCV'd

A1 B1 C1
04-01 04-02 04-03
A2
FR SA SU

NEXT MONTH
A1 B1 C1
05-01 05-02 05-03
A2
SU MO TU

In the above example, DAY in B2 changes from SA to MO.

Row 2 has the DAY "formatula" based upon the value of Row 1, hence I don't
know how the =LEFT(TEXT(B2,"ddd"),2) would trigger the MO condition.

As well, each cell in the range which has the conditional format would refer
to a relative cell, not an absolute.

Any thoughts are appreciated ...

Mun'D

"Biff" wrote:

> Hi!
>
> Can't understand what it is you want to conditional
> format. Maybe post back with a more descriptive
> explanation.
>
> In the mean time, you can shorten that formula to:
>
> =LEFT(TEXT(B2,"ddd"),2)
>
> If you need to test for an empty cell:
>
> =IF(B2="","",LEFT(TEXT(B2,"ddd"),2))
>
> Biff
>
> >-----Original Message-----
> >Where ROW=DAY, want COLUMS to SHADE therefore it is
> not "cell specific" as to
> >THAT cell's content, but I want that column's cells to
> shade based upon a
> >specific cells value or formula.
> >
> >ROW 2
> > A2 B2
> > 04-01 04-02
> > hard =A1+1
> >
> >ROW 3
> >=IF(WEEKDAY(B2)=2,"MO",IF(WEEKDAY(B2)=3,"TU",IF(WEEKDAY
> (B2)=4,"WE",IF(WEEKDAY(B2)=5,"TH",IF(WEEKDAY(B2)=6,"FR",IF
> (WEEKDAY(B2)=7,"SA",IF(WEEKDAY(B2)=1,"SU","")))))))
> >
> >I want ColB to shade if result of above formula is X day
> (Monday).
> >.
> >
>