Adding in another conditional format on the same cell

[Guest]

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....

 

[Biff]

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

 

[Guest]

Well...its like that.....first u had taught me on the "due date" formula
right....so when 2 weeks b4...it switch to "orange" colour....on the due
date..it turns "red".......Now i need another formula in the same cell...can
i? coz i knew for the Conditional Format........maximum we can insert 3
conditions in it .....

The formula i need is...when i key a "B" in the next column....the same cell
but for this time....the "font" colour change instead ..... to e.g. "green"
because ...the "B" stands for a Nationality for our information....

I hope u understand what i mean .....Looking forward to hear from u very
soon....
Please advice again..Thanks
"

 

[Biff]

Hi!

Unfortunately, it isn't that simple.

I can't figure a way to make it work. You have too many conditions even
though IT MAY SEEM like you only have 3.

Here's the problem:

If the due date is within 14 days and cell ?? equals B - one condition
If the due date is within 14 days and cell ?? <> B - one condition
If the due date equals today and cell ?? equals B - one condition
If the due date equals today and cell ?? <> B - one condition
Cell ?? equals B - one condition
Cell ?? <> B - one condition

There's no way to meet all those combinations in only 3 conditions.

Take a look at this site:

http://xldynamic.com/source/xld.CFPlus.Download.html

They have developed an add-in that allows up to 30 (I think) conditions.

Either that or you need some VBA code to do what you want but I can't help
you with that.

Biff

 

[Bob Phillips]

Take a look at this site:

http://xldynamic.com/source/xld.CFPlus.Download.html

They have developed an add-in that allows up to 30 (I think) conditions.

Either that or you need some VBA code to do what you want but I can't help
you with that.

If you want VBA code as Biff suggests, confirm if his understanding is
correct or not, and what colours go with the different variations.