Forum Discussion

Karla p's avatar
Karla p
Copper Contributor
Oct 02, 2017

Excel Conditional Formatting comparing dates & cost

Hello,

I need help figuring out the correct conditional formatting to apply for two issues:

 

1) I have two columns of dates (in col D & E). I need to compare these dates, so that if the date in col E is 14 days past the date in col D, the date in col E will turn red.

 

2) I have two columns of accounting/money amounts.  I need to compare these two amounts of money spent, so that:

  • if, the money amount in col B is 10% more than the amount in col A, then the amount in col B turns red.  
  • if, the money amount in col B is 20% less then the amount in col A, then the amount in col B turns yellow.

Resources