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($C3:D3))
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