DrPhil
Outstanding Member
Practically need a sub forum at this stage...
Apologies. I have googled this but it's not quote catching my drift.
I want to apply conditional formatting to a cell based on the result of another cell.
Example:
Column 1 - name
Column 2 - 1st payment
Column 3 - 2nd payment
2 rows, column 1 they're merged as both are for the same name.
Name---------01/10/20--------01/11/20
Name-------------£500---------------£250
The easy part is getting the dates on the first row to format, red for overdue, orange for due soon, green once the payment is complete and I remove the date and write "complete"
But I want that colour to apply to the amount too. In other words once the payment on Oct 1st is overdue both the date cell and the £500 go red. And when it's done and I change 01/10/20 to "complete" the figure stays but both cells go green.
Advice appreciated as always!
Apologies. I have googled this but it's not quote catching my drift.
I want to apply conditional formatting to a cell based on the result of another cell.
Example:
Column 1 - name
Column 2 - 1st payment
Column 3 - 2nd payment
2 rows, column 1 they're merged as both are for the same name.
Name---------01/10/20--------01/11/20
Name-------------£500---------------£250
The easy part is getting the dates on the first row to format, red for overdue, orange for due soon, green once the payment is complete and I remove the date and write "complete"
But I want that colour to apply to the amount too. In other words once the payment on Oct 1st is overdue both the date cell and the £500 go red. And when it's done and I change 01/10/20 to "complete" the figure stays but both cells go green.
Advice appreciated as always!