Hi,
I have a conditional formatting which is causing me a headache. Using formulas, I want the cells to be highlighted in certain colours based on certain conditions, a bit tricky to explain but attached file shows an example.
One rule is that if the overall value ("middle cell") is lower than 1%, the fields should be whitened (as this small share is not relevant to look at). It works fine when total is 0% (and all related values are "DIV/0!"). However, if the total is between 0 and 1 but all related values equal zero, it does not work any more. I think it has to do with the other rules eliminating each other but I don't know what to do. I tried changing the order of the conditions but can't get it to turn white...
Any suggestions??
Additional comment: Just realised that the same "error" occurs when not all "realted values" are zero. Then colour is chosen according to which is the largest although it should be white due to the total being below 1%...
Big thanks already!!
Wiebke
Bookmarks