Colours

[annonymous]

OS Win.XPPro SP2, Office 2003

When I am working on a Cash Flow I want the negative balances, which appear
in the Balance Column only very rarely on some days to be highlighted
immediately in red, and not just with a minus sign in front.
Is there a way of Formatting the Balances Column in such a way that the
negative balances would automatically show with the minus sign and in read,
whilst the positive balances stay in black? Your help on this will be
greatly appreciated. Thank you.

 

[Bernie]

Select the cell or range of cells, then right click the selected cells and
select Format Cells on the Number tab choose the Category Currency and
scroll down the Negative numbers list to choose your preference then select
OK.