Hello everyone!
Im having an issue with condtionally formatting multiple date cells to highlight if over one year from original date from cell. Its for a tracker for training certificates that expire after 1 year from completion date. To give an example: Suicide Awareness training was completed on 25-Dec-11 would still be good as of today but if it was completed on 5-November-11 it would be expired. There are multiple different dates going down in the columns. I would like to highlight the expired training in red. Any help is appreciated! If you need more info please let me know.
Bookmarks