Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to click on a cell and have the content of the cell display in a different cell | Excel Worksheet Functions | |||
Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) | |||
Can i tell the cell to equal the pattern in another cell? | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |