I used the formatting wizard that is not built in but it only compares to todays date and I can't use the date of a field. Excel formulas for conditional formatting based on another cell - the tutorial provides a handful of examples that demonstrate how to format individual cells or entire rows based on another cells value in Excel 2016, 2013, 20. I have done this for another list using the status of the request of whether it was approved or rejected but when it comes to dates I have found it rather difficult to get an example even close to what I am looking for. I would like to use conditional formatting to create a status column that shows me the certificate is one of these:Ĭurrent, green background - taken sometime within the last 10 months.Įxpiring, Orange background - Taken 11 or 12 months ago.Įxpired, Red background - date past one year ago In SharePoint O365, in the modern experience, I have a list of training certificates that have an expiration date of one year from date taken.
0 Comments
Leave a Reply. |