This shows how to highlight when it is overdue, but what happens if it is overdue, the cell turns Red, and the invoice is subsequently paid? e.g. you have another cell showing paid date which over rules the initial format of Red and turns the cell to Green once the paid cell is completed?
Yes, you could add another column and then create another rule to mark it green if the paid date cell is not blank. Then you’d just have to make sure that rule was first in the hierarchy of rules so that it got applied first
@@SpreadsheetNation I have done this, but as I have 4 rules, I notice the cell applies the 1st rule. How do I combine the rules eg If within 1 day it is Red, up to 7 days it id Amber, up to 30 days it is yellow, and if there is a date in the completed column, it is Green. Trying to combine them all so I get a traffic light system in place depending how close to the completion date listed.
Mines keeps giving me a calendar date not a number count
What about the color changing for date paid. For example, green for completed...
This shows how to highlight when it is overdue, but what happens if it is overdue, the cell turns Red, and the invoice is subsequently paid? e.g. you have another cell showing paid date which over rules the initial format of Red and turns the cell to Green once the paid cell is completed?
Yes, you could add another column and then create another rule to mark it green if the paid date cell is not blank. Then you’d just have to make sure that rule was first in the hierarchy of rules so that it got applied first
@@SpreadsheetNation Thank you, I will try that and play about with it. It's been 15 years since I did similar and forget it all now. Back to basics.
@@SpreadsheetNation I have done this, but as I have 4 rules, I notice the cell applies the 1st rule. How do I combine the rules eg If within 1 day it is Red, up to 7 days it id Amber, up to 30 days it is yellow, and if there is a date in the completed column, it is Green. Trying to combine them all so I get a traffic light system in place depending how close to the completion date listed.
Bruh I've been trying to figure out how to do this for like a month.