Hey,

I have a excel file with sales amounts per week per item. This file is
automatically update from a different auto generated file. With formulas like
='G:\xxx\Sales\Delivery schedules\[DATA.xlsx]Blad1'!E3 each cell is filled.
With this data I create new views like what is in stock (of items in order),
when I have to deliver a part, etc.

The problem is that some cells are not affected by conditional formatting.
When I change the formula to a hard number, the cell is affected. Any idea
how I can fix it?

Thanx!