this is my question
for applying to entire sheet
A whole number must be shown without decimal point.
Number with decimal point must be shown up to 2 decimal point.
A negative number must be shown in color red with the negative sign.
How to do using using the FORMAT CONDITIONS for entire sheet?
i cufrently did "selecting the entire sheet, then chose format conditions, under number, i selected custom , and typed
"General;[Red]-General;;@"
but it seems to be nor 100% correct