Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
Sure, I can help you with that! You can use conditional formatting to achieve this. Here are the steps:
Now, any negative numbers in the selected cells will be displayed in red, and any positive numbers will be displayed in green. As the data changes, the formatting will update automatically.
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Just set the normal text in those cells as GREEN, and format them to display
negative numbers as RED.....note, zero also is displayed as GREEN this way.... Vaya con Dios, Chuck, CABGx3 "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. |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
try conditional formatting
"CLR" wrote: Just set the normal text in those cells as GREEN, and format them to display negative numbers as RED.....note, zero also is displayed as GREEN this way.... Vaya con Dios, Chuck, CABGx3 "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 97 formula doesn't work in Excel 2003 | Excel Discussion (Misc queries) | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) |