Hi!

What exactly are you trying to add as another condition? Be very specific
with your explanation.

I helped you on your original post(see it for a new reply to your follow-up
question).

When you have multiple conditions(as you do) then you have to be careful as
you assign "priority" to the conditions.

Biff

"Kelly Lim" wrote in message
...
Dear everyone..
I have a cell containing "conditional format" when 2 weeks before the
due
date ...the cell colour changes to "orange"....it turns red when it
reaches
the "due date" .....
Now.......i need to add in another condition ....when i add in another
column e.g. "B" and the font colour will change to "yellow" ....i think
its
something to do with....if equal to....then it would change to this
colour.... Can someone teach me the formula pls? urgent....thanks
everyone....