i have conditional formatting in column K, it highlights red after 30 days have elapsed from due date (column I) and is in black when less than 30 days from due date. what i want to is for column K to change to blue when paid and the text to show PAID. its needs to be formatted for google docs.
Solved by G. J. in 19 mins