| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Despite formatting a column in Excel 2002 worksheet as Short Date. | Excel Discussion (Misc queries) | |||
| how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| How to apply conditional formatting with incremental address for . | Excel Worksheet Functions | |||
| Simplify Process with Excel 2003 | New Users to Excel | |||
Threaded Mode
