Forum Discussion
Formula help
Hi, I am having a problem where I'm using a formula to change the colour of a cell based on a date: =AND(D6<>"", D6-TODAY()>=60) - Turns green =AND(D6<>"", D6-TODAY()>=1, D6-TODAY()<60) - Turns ...
Try replacing the D6 in your formula with this: =1*INDEX(TEXTSPLIT(D6," "),1)
the D6 at the begining is it so it will be:
=AND(=1*INDEX(TEXTSPLIT(D6," "),1)<>"", D6-TODAY()>=60) - Turns green
is that what you mean?
thanks.