• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting I Think.

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.
 
You didn't specify where the Payment date is

So I have assumed Column F


Select I2

Goto conditional formating and use a formula

=F2>=E2

Change the Format to Red + Bold

Apply

Copy the cell down
 
Back
Top