I have a spreadsheet with dues dates and amounts to be paid. If the due date is today or past due I want it to be red and bold... I know you can do that with conditional formating... BUT I want it to go back to regular font and black when there is an amount in the amount paid column. Any solutions? Thanks for all help!! (Also the date needs to stay the same and not be deleted.)