Hello,
I am creating a training database with an overview sheet. Sheet 1 is the overview and the sheet 2 and on are the training database for various types of training.
I have a formula that changes a cell on Sheet 1 orange when the expiration date in Sheet 2 D5 is 45 days from today and red when the expiration date has passed. I can't figure out the formula however to make the overview sheet cell green when a date of training has been entered in Sheet 2 B5.
Also am I correct that if I order the rules in conditional formatting, I can have the last rule over right the ones before it?
Any help is greatly appreciated. Thank you
Bookmarks