i have a spreadsheet im working on. i have a column of invoice due dates. It has a conditional format that says "cell value is less than =today()" it turns the font red. i need to make it turn back once there is anything typed into another column saying it was paid.
Im having trouble with this and im new to excel.