Hi Mat,

I have a similar problem as yours. I have cells A which calculate a value. The conditionally formatted cells B have conditions based on the values calculated in Cells A. Cells B are linked to another sheet. However, the colors are not changing.

I think it is because the calculations in Cells A are happening at the same time as the cells in group B are being filled.

Can you please let me know how you solved your problem?

Thanks,
Trisna