IF funtion

[PVON1332]

I have an older version of Excel, good to get that clear. I would lik
to set up my excel spreadsheet, so that when a certain cell DOESN
equal zero, whatever number in there TURNS RED. And when it finall
equals zero, it goes back to black.

The spreadsheet is for a company and we are watching to make sure n
one owes money. If they still owe money, we want it to show up in RE
and it just takes TOO long to always change the colors.

If you could please help me that would be great. If you could email m
the answer that would be even better! (e-mail address removed)

Thanks!

 

[firefytr]

hi, don't know what ver of excel you have, you never specified. but if
you have conditional formatting (Format -> Conditional Formatting) add
a condition to where Cell Value Is -> Less Than or Equal To -> 0 -> set
Format.

hth

 

[Don Guillett]

which version. Look at HELP>about

 

[Anders S]

One way is to go to Format>Cells>Custom and enter something like
# ##0,00;[Red]-# ##0,00
See Excel Help for details.

Another way is to use Format>Conditional Formatting if that is available in your
"older" Excel version.

HTH
Anders Silven