cell pattern depening on cell content
hello,
I want to accomplish the following: When the cell content is a negative number, i want the cellcolor to be red, when the cell content is a positive number, i wnat the cell collo to be green. But If this isn't possible, then maybe the following: a positive numùber is displayed in green, a negative number is displayed in red (this is possible through cell format options) |
cell pattern depening on cell content
Go to Format-Conditional formatting. Set it how you want such as "Cell value
is" then "Less Than" and finally 0. Click the format button and select what you want the cell to look like when it is less than zero. Click Add to add a rule for =0 or above 0 -- -John Please rate when your question is answered to help us and others know what is helpful. "stevendeferme" wrote: hello, I want to accomplish the following: When the cell content is a negative number, i want the cellcolor to be red, when the cell content is a positive number, i wnat the cell collo to be green. But If this isn't possible, then maybe the following: a positive numùber is displayed in green, a negative number is displayed in red (this is possible through cell format options) |
All times are GMT +1. The time now is 06:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com