Problems with conditonal formatting

[Guest]

I have a pivot table that contains a list off part numbers (starts A3 going
down) , the current qty in stock (start B3 going down), the the week no due
(starts c2 going left to right) and then the qty req in the corresponding
area. I also have the current week number in IR4

In E3 for example I am have conditionally formatted as follows:
1. CELL VALUE IS LESS THAN OR EQUAL TO =SUM($B3-SUM($C33))
2. FORMULA IS =E$2<=$IR$4

What this should do is fill in cells that I have enough material for in a
colour and also change the text colour of cells the are equal to or less that
the current week number.

where it is going wrong is that when I have enough material to cover a week
that is equal to or lee than the current week it filling it in a colour but
is not highlighting the text.

How can I conditionally format using both critiria?

regards

 

[Bernie Deitrick]

Rook,

You need to combine them into one: when there are more than one CF, the first one that matches the
criteria is applied.

Try something along the lines of (I'm just guessing here....):

FORMULA IS
=AND(E$2<=$IR$4,E$2=SUM($B3-SUM($C33)))

HTH,
Bernie
MS Excel MVP