View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers
 
Posts: n/a
Default Excel: want neg numbers to show red/pos green via if-then formula

Look at Format==Conditional formatting.

Select column then Format=Conditional formatting:

Condition 1 == Cell Value is: less than 0, set font to RED
Condition 2 == Cell Value is: Greater than 0, set font to GREEN

HTH

"Jim" wrote:

I am trying to have the negative numbers in a cell turn red and positive ones
turn green as the values change. I would like a formula that says "If number
is negative, display text red" and "If positive then display green."

I know you can make negative numbers red in options, but the spreadsheet is
linked to data that changes in real-time and would like it to automatically
change.