Code:
Hi,
I creating a permit register.
End Goal : Have the text in both Cells in "Start Date" and "Finish Date" have the same colour to determine if the Permit is 'Expired', 'Current' or set in the 'future'
Column H (Permit Start Date) and Column I (Permit Finish Date).
Permit dates do not have a set amount of time and are subject to the individual inputting data - they will always be changing.
So this is how I want it to look:
Permit Start Date | Permit Finish Date |
2/11/2019 | 3/11/2019 |
1/11/2019 | 12/11/2019 |
9/11/2019 | 10/11/2019 |
Thanks for your help