Showing negative balances in red

I've set up a spreadsheet for eBay sales, but prior to any sales having
been made it shows negative balances, what with listing costs and so on.
How do I get it to show those negative balances in red, reverting to
black when a credit balance is achieved?

Thanks in advance

Ricardo

look at format>number>currency or accounting

--
Don Guillett
SalesAid Software
[email protected]
"Ricardo" <[email protected]> wrote in message
news:[email protected]...
> I've set up a spreadsheet for eBay sales, but prior to any sales having
> been made it shows negative balances, what with listing costs and so on.
> How do I get it to show those negative balances in red, reverting to black
> when a credit balance is achieved?
>
> Thanks in advance
>
> Ricardo

Thanks Don, very much appreciated. I knew it was there, but didn't know
where to look.

Regards,

Ricardo

Don Guillett wrote:
> look at format>number>currency or accounting
>

glad it helped


--
Don Guillett
SalesAid Software
[email protected]
"Ricardo" <[email protected]> wrote in message
news:[email protected]...
> Thanks Don, very much appreciated. I knew it was there, but didn't know
> where to look.
>
> Regards,
>
> Ricardo
>
> Don Guillett wrote:
>> look at format>number>currency or accounting
>>