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)
| 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
|