Hi,

I have a budget sheet where I am using conditional formatting for have 3 colours to show values when they are over my budget to be red, no colour when the value is zero and green when the value is under my allocated budget.

My problem is on one sheet the formatting is working fine but as I got my next sheet it doesn't work. Zero value is turning red which should be white.



I have copied my formula/formatting from the sheet where its working and pasted it on the second sheet but the problem is still the same.

any help on this please.

kP

Any chance you could attach your workbook? It could be anything. If I see it, I'll probably be able to figure it out quickly.