i have conditionally formatted Cell A7 to go red 5 days before and 5 days after today's date. i want to switch the conditioning of in this cell if an 'S' is entered into B7.......how do i do that