View Single Post
 
Old 07-02-2014, 07:40 PM
parachamk parachamk is offline Windows 8 Office 2010 32bit
Novice
 
Join Date: Jul 2014
Posts: 1
parachamk is on a distinguished road
Question conditional formatting - I am confused

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
Reply With Quote