I have a formula within a cell that provides a date. I formatted the cell to only show me the day of the week (Monday, Tuesday, etc). I would like a conditional format that if the value of the formula is Saturday fill in the cell with blue and if the value of the formula is Sunday fill in the cell with red.
any ideas???
any ideas???