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(WE EKDAY(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(W EEKDAY
(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(WE EKDAY(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(W EEKDAY
(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).
.