Forum Discussion
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...
examble for Contitional Formating
1) =$I$6<=TODAY() +60 Explain : I6 = Expiry Date , TODAY Date is automaticaly from systen generate, +60 Explain: is the 2 months option for info before expire.
2) =$I$6<=TODAY() Explain: the same end date if is expire
3) =$I$6>=TODAY() Explain: if the ticket not are expired
I would be happy to find out if I could help.
Nikolino
I know I don't know anything (Socrates)
1) =$I$6<=TODAY() +60 Explain : I6 = Expiry Date , TODAY Date is automaticaly from systen generate, +60 Explain: is the 2 months option for info before expire.
2) =$I$6<=TODAY() Explain: the same end date if is expire
3) =$I$6>=TODAY() Explain: if the ticket not are expired
I would be happy to find out if I could help.
Nikolino
I know I don't know anything (Socrates)
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.
- 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)
Thank you so much for taking the time to help me.
This does not seem to work for me. When you write =$I-6 <=TODAY()+60 is that what I fill in or do I write =$May 16, 2022<=Today(). Once I try to add the last rule =$I-6>=TODAY() it does not allow me to do it and asks me to add a ' in front of the =.
NAME Confined Space Entry/Monitor Crane and Rigging EWP Fall Pro Fire Extinguisher Safety First Aid Forklift Health and Safety Committee Reps Site Specific WHMIS 2015 Steve April 16, 2022 February 12, 2023 February 11, 2023 May 17, 2022 April 3, 2020 October 28, 2019 Chris July 7, 2020 November 20, 2023 November 19, 2022 Wayne Arthur July 7, 2020 April 23, 2020 Wade April 16, 2022 October 27, 2020 October 6, 2020 July 12, 2021 March 6, 2022 Dylan April 16, 2022 September 23, 2019 Judy Susan March 11, 2022 Jarrod July 7, 2020 October 24, 2020 September 23, 2019 Mark September 19, 2020 April 2, 2021 September 18, 2020 Leslie April 16, 2022 February 26, 2023 March 5, 2022 April 17, 2020 April 23, 2020
