accountingblm
New Member
I have a pretty large spreadsheet that I use on a weekly basis to track vendor payments. In column E i have the payment date and in column I i have the payment amount. Now I use red text to indicate the payment has not been made and I use black text to indicate that the payment has been made. What I'm trying to accomplish is that when the cell with the payment about has come to equal or be greater than the payment date in the E column that the text in the payment amount(Column I) turn from red to black. Hopefully i explained this well enough. Thanks in advance for your help.