View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
greenfinger
 
Posts: n/a
Default 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?