EXCEL 2003: Apply Conditional Formatting to COLUMNS

[HWDFWXCLGuru]

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
=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).

 

[Biff]

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

 

[LanceB]

Select all colums to format

In Format|Conditional Formating

Change "Cell Value is" to "Formula is"

and enter =WEEKDAY($A1)=2

Lance