Conditional Formating multible if statements
 

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?

I am not sure why your existing equations work, but try

=IF(and(v11=TODAY(),or(X11="",X11="Pending")

etc.

"Roy" wrote:

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?

Hi Roy-

As I interpret it, the "CF went to the default" because the content of the
cell *did not* test TRUE for either condition. The fact that you entered
something ("pending") in the cell will not prevent the CF from applying if
you replace "pending" with something that does satisfy one of the other
conditions.

In fact, you could even apply a 3rd condition to format another way if Cell
Value is equal to pending.

HTH |:)

"Roy" wrote:

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?

BJ,

I not sure why the existing equations worked but it did what I wanted at the
time. I Entered the formula that you suggested and it did not work, I tried
instead of =IF(And((v11=today(),or(x11="",x11="Pending"), i dropped the "AND"
to make it work.

"bj" wrote:

I am not sure why your existing equations work, but try

=IF(and(v11=TODAY(),or(X11="",X11="Pending")

etc.

"Roy" wrote:

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?

I see now why your equation worked.
your if "if true" statement has a true or false response which is what you
want for the conditional format

the reason mine did not work is that I left off a final ")"
mine also would have worked as

=and(v11=TODAY(),or(X11="",X11="Pending")


"Roy" wrote:

BJ,

I not sure why the existing equations worked but it did what I wanted at the
time. I Entered the formula that you suggested and it did not work, I tried
instead of =IF(And((v11=today(),or(x11="",x11="Pending"), i dropped the "AND"
to make it work.

"bj" wrote:

I am not sure why your existing equations work, but try

=IF(and(v11=TODAY(),or(X11="",X11="Pending")

etc.

"Roy" wrote:

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?