I previously posted in regards to getting the formula to highlight a cell based on a date in column I either being expired or set to expire within 14 days. Using conditional formatting, the formula is: =AND($I8<>"",$I8<=TODAY()+14)
I would like to adjust the formula to change the colour if it has expired or is set to expire in 14 days AND if nothing is in column L on the same row. Does anyone know how to adjust the formula to accomplish this?
Bookmarks