Conditional Formating Help . .

[Evagrius Ponticus]

Hi, I have three conditions and I was wondering if a fourth was possible.

1.

=AND(ISNUMBER(VALUE(LEFT(X16,1))),$AW16="Sales")

2.

=AND(X16="X",$AW16="Sales")

3.

=X16="-"

The fourth one that I need would change the font to white if $E$7 or $E$8 were blank. I tried to add that as an OR in the 3rd condition but no luck. Thanks,

 

[Norie]

The limit, pre 2007 anyway, is actually 3 formats not conditions.

Does the 3rd condition currently do the formatting you want?

If so perhaps a formula like this:

=OR(X16="-", $E$7="", $E$8="")

 

[Evagrius Ponticus]

Hi Norie - don't have 2007. I tried your suggestion before I posted but it doesn't work. The third condition does work now - but when I add with the OR it doesn't.

 

[Norie]

Does the formula work correctly in a cell on the worksheet?

 

[Evagrius Ponticus]

Hmmm, if I place the formula in a cell, and e7 and e8 are not "", then I get a false. If I delete e7 then I still get a false. If I keep e7 and delete e8, then I get a VALUE! error. E8 is custom formatted though - could that be why?

 

[Norie]

I've just tried the formula with a few scenarios and I wasn't able to generate any error.

As far as I'm aware custom formatting shouldn't affect it - formatting doesn't actually change the value it does what it says, format.

Any of the cells contain formulas?

 

[Evagrius Ponticus]

Thanks Norie - I had to adjust the formula in the cell