C
changetires
Condition 1
Cell value is Less than 0 then RED
Condition 2
Cell value is Greater than or equal to 0 then Green
this is what is in the conditional formatting boxes but for some reaso
when the value in the cell =0 the cell turns red instead of green. Th
value in the cell will always read a positive number because of in th
individual cell formatting I have this written in the custom men
#,##,0.00;#,##,0.00
this conditional formatting works in other sheets but for some reaso
it doesnt work in this particular sheet.
any ideas?
Thks
E
Cell value is Less than 0 then RED
Condition 2
Cell value is Greater than or equal to 0 then Green
this is what is in the conditional formatting boxes but for some reaso
when the value in the cell =0 the cell turns red instead of green. Th
value in the cell will always read a positive number because of in th
individual cell formatting I have this written in the custom men
#,##,0.00;#,##,0.00
this conditional formatting works in other sheets but for some reaso
it doesnt work in this particular sheet.
any ideas?
Thks
E