Hi,
I have a training spreadsheet where I record the dates of passing tests/assessments, some of these assessments have a timelapse period.
User enters dates into the date column field (red cell) and in a subsequent column (green cell) the amount of months until this assessment is required again.
I'd like to conditionally format the column of dates (E,F etc) so that the individual cells turn red after the amount of months are up (W)
I do not want to add another column with the a run out date as multiple employees will be listed in the sheet and it'll just make it more complex.
What formula do I use in conditional formatting please?
skills regsiter.jpg
Many thanks
Paul
Bookmarks