Forum Discussion
Daveyboy1981
Jul 15, 2020Copper Contributor
Conditional Formatting for dates
I have a spreadsheet with names going down on the left side column, at the top going right in the columns I have courses people have taken. In each intersecting cell there is the date of expiry for t...
Daveyboy1981
Jul 15, 2020Copper Contributor
So I have made an example of what I have. The dates in the boxes are expiry dates. Should i have the dates in there for when the ticket was acquired? I would like to have all formulas the same and green from date acquired, yellow when they reach 2 years 10 months and red on expiry.
NikolinoDE
Jul 15, 2020Platinum Contributor
a small example in the file ... i am not sure if that is what you are looking for ... because the translation in german is not the best ... if not that what you are looking for, please give me a short message ...
if this is what you are looking for, please give me short message with a thumbs up 🙂
anyway i would be happy to find out if I could help.
Nikolino
I know I don't know anything (Socrates)