Hi All
I have a sheet with a date in column A and a lookup list in column J, i'm trying to change the lookup list item to 'Exhausted' once 30 days have passed sonce the imput date (column A).
I can change the colour using conditional formatting with;
=A2<TODAY()-30
However I can't seem to get it to change to the lookuplist item.
Any suggestions?
Thanks
Alex
I have a sheet with a date in column A and a lookup list in column J, i'm trying to change the lookup list item to 'Exhausted' once 30 days have passed sonce the imput date (column A).
I can change the colour using conditional formatting with;
=A2<TODAY()-30
However I can't seem to get it to change to the lookuplist item.
Any suggestions?
Thanks
Alex