Hi all,
I have a couple of questions around cell formatting.
First is around condition formatting. I have some cells which I need to colour based on value. > 5 colour red. <6 colour green. One group of cells is conditionally formatted this way but another group of cells which looks to be formatted the same doesn’t return the same result…. It seems to work with numbers other than zero which should fall under the <6 category and be green but it this case it returns red.

This leads to my other question about zero’s. The cells that I want to conditionally format come from another sheet, if there isn’t an any data in the cell to be copied it return 0. This throws out my sheet as some of the valves will be 0. So I want the 0’s when they’re there but nothing when the reference cell is empty..

Any idea’s.

Thanks Dave