Hi everyone, I would greatly appreciate some help.
I am trying to set up a rule across two different sheets within the same workbook.
On the first sheet which is a summary sheet for all the sheets in the workbook, I have cells containing dates as to when a questionnaire was completed. On the second sheet, which goes more into the detail, I have a 4 cells - one: containing the date it was originally done, two: the date it is due to be updated, three: a formula turning the cell red when the due date cell (two) is out of date, and four: a cell with a 'number of days' formula ( I hope this is all understandable).
What I am trying and hope I can do is:
- On Sheet 1, turn the cell with the original date red WHEN on Sheet 2, that date's corresponding red due cell (cell three) has automatically highlighted.
If this is not possible and you have an idea of how I should do the formatting instead, I welcome all insight and ideas. Thank you!
