Forum Discussion
Karla p
Oct 02, 2017Copper Contributor
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.
2 Replies
Sort By
What's wrong with Carlos's solution?
- CARLOS ADRIANCopper Contributor