Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: how can cell contents be coloured if they are negative?
I have set up a spreadsheet for financial accounts and wish to highlight
results where the balance is less than zero. Is there a way of writing a cell formula or another way of showing negaitve results in, say, a red colour both on the screen and in print? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: how can cell contents be coloured if they are negative?
-- HTH RP (remove nothere from the email address if mailing direct) "greenfinger" wrote in message ... I have set up a spreadsheet for financial accounts and wish to highlight results where the balance is less than zero. Is there a way of writing a cell formula or another way of showing negaitve results in, say, a red colour both on the screen and in print? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: how can cell contents be coloured if they are negative?
Use a custom format, along the lines of
#,##0,[Red]-#.##0 -- HTH RP (remove nothere from the email address if mailing direct) "greenfinger" wrote in message ... I have set up a spreadsheet for financial accounts and wish to highlight results where the balance is less than zero. Is there a way of writing a cell formula or another way of showing negaitve results in, say, a red colour both on the screen and in print? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: how can cell contents be coloured if they are negative?
Hi, One way, in the format cell option select Currency as the "Catagory" and in the "negetive numbers" select the red negetive numbers. Another way is to use conditional formatting, Format/Conditional Formatting....cell value is "less than" and type 0, then choose your format. HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=490563 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: how can cell contents be coloured if they are negative?
Hi pinmaster Many thanks - I am a new user so I had missed the obvious solution. Exactly what I wanted. greenfinger "pinmaster" wrote: Hi, One way, in the format cell option select Currency as the "Catagory" and in the "negetive numbers" select the red negetive numbers. Another way is to use conditional formatting, Format/Conditional Formatting....cell value is "less than" and type 0, then choose your format. HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=490563 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel - insert cell contents in a custom header / footer | Excel Discussion (Misc queries) | |||
Can I use cell contents to update footers in excel? | Excel Discussion (Misc queries) | |||
Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |