View Single Post
  #1   Report Post  
HWDFWXCLGuru
 
Posts: n/a
Default 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).