Forum Discussion
How to change colour to one cell based on expiration status of multiple cells in a different sheet
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Try if you can see the document with this link?
Thanks. I see that you have different colouring rules for different types of training - some involve TODAY()-365, others TODAY()-1095, etc.
Do you want to mimic that faithfully on the master list sheet, or do you want to use a uniform rule?
HansVogelaar thank you for looking into this! Yes, some trainings expire in one year, some in two and some in three, so I had to make different rules.
I would like for the master list to "colour itself" if anything in the relevant sheet is anything but green (if something is about to expire the cell should be yellow and if anything has expired should be red, so at a glance if I see that someone has anything but green I can immediately investigate).
I thought of this because we have another sheet with a LOT more trainings and the idea of having to go sheet by sheet column by column was not feasible, or there was the risk of getting things confused or forgotten.
The UNI Training is doable, but the Hospital Training is difficult, since the rules vary from column to column. It'll require VBA, so it'll work only in the desktop version of Excel for Windows/Mac, and users would have to allow macros. Is that feasible?
