Text color rules
I'd like to make numbers <0 green and numbers <0 red
how do i do that? thanks |
Ponk
FormatConditional FormattingCell value is: less than 0, format to green. Add and under Condition2 Cell value is greater than 0, format to red. I am assuming a typo in your original post where you have both <0 Gord Dibben Excel MVP On Wed, 30 Mar 2005 07:48:47 +0800, "Ponk" wrote: I'd like to make numbers <0 green and numbers <0 red how do i do that? thanks |
Yep that was a typo.
thanks! "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Ponk FormatConditional FormattingCell value is: less than 0, format to green. Add and under Condition2 Cell value is greater than 0, format to red. I am assuming a typo in your original post where you have both <0 Gord Dibben Excel MVP On Wed, 30 Mar 2005 07:48:47 +0800, "Ponk" wrote: I'd like to make numbers <0 green and numbers <0 red how do i do that? thanks |
Conditional formats are better, but a custom format, or custom Style is
another option: [Red]General;[Green]General;General .... I'd like to make numbers <0 green and numbers 0 red -- Dana DeLouis Win XP & Office 2003 "Ponk" wrote in message ... I'd like to make numbers <0 green and numbers <0 red how do i do that? thanks |
All times are GMT +1. The time now is 07:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com