In CF condition 1 I have Formula is =IF(v11=TODAY(),X11="")
format is RED.
In condition 2 my formula is IF(V11=TODAY()+3,X11="")
format is YELLOW.
Columns V11=Date Due and X11=Date Complete

This CF works until I found out in some cases I can't put a date completed
because I am waiting customer authorization, so I started entering pending
and when I did that the CF went to the default. What I want to know is if I
enter pending in X11 can I still apply the above conditions until I enter a
date in the date completed column?