Hi all
I have exhausted google with this question but everything I've tried has not worked. I'd like to do the following
If the date in I1 is 30 days away and J1 is blank, flag I1 orange.
If the date in I1 is in the past and J1 is blank, flag red.
Once a date is in J1 then I need it to be white. So far I was trying this kind of thing:
But had no luck. any help would be much appreciated thanks
I have exhausted google with this question but everything I've tried has not worked. I'd like to do the following
If the date in I1 is 30 days away and J1 is blank, flag I1 orange.
If the date in I1 is in the past and J1 is blank, flag red.
Once a date is in J1 then I need it to be white. So far I was trying this kind of thing:
VBA Code:
=IF(AND(=I5-TODAY()<30,J5=””),0,1)