Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WEEKDAY in Conditional Formatting?
Excel2003 ... My Cols are A thru H =
Date - Mon - Tue - Wed - Thu - Fri - Sat - Sun Cell A2 = a date (or is blank (empty)) ... format = mm/dd/yy Cells B2 thru H2 contain Conditional Formatting as follows: Cell B2 ... =if(weekday(A2,2)=1 Cell C2 ... =if(weekday(A2,2)=2 Cell D2 ... =if(weekday(A2,2)=3 Cell E2 ... =if(weekday(A2,2)=4 Cell F2 ... =if(weekday(A2,2)=5 Cell G2 ... =if(weekday(A2,2)=6 ... this one is a problem??? Cell H2 ... =if(weekday(A2,2)=7 All above are working ok, except ... =if(weekday(A2,2)=6 ... this formula in Conditional Formatting is setting off the Conditional formatting when Col A reference cell is BLANK (empty) ... Anyone know what gives? Note: if I place "=6" in any of the other Cells it also sets off the Conditional formatting when Col A reference cell is BLANK (empty)??? Thanks ... Kha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting | Excel Worksheet Functions | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |