Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill color to a cell when the value is negative or positi
how do you color in a cell when its calculated value is negative is negative
or positive, say light red for negative and light green for positive? thx, musch appreciated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill color to a cell when the value is negative or positi
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill color to a cell when the value is negative or positi
Click on Format, Conditional Formatting. Use Cell Value Is, change centre
selection to "Less Than", insert a zero in the right hand box, click on Format, Patterns, select the colour of your choice, click OK,Click on Add, repeat the process, but change from Less than to Greater than, and OK out. With a 0 or nothing, the cell will have no fill, with -1 it will change to red fill, and with 1 it will change to light green "temetua" wrote: how do you color in a cell when its calculated value is negative is negative or positive, say light red for negative and light green for positive? thx, musch appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fill one cell color with text html/rgb color from another | Excel Discussion (Misc queries) | |||
Find and replace specific characters within a cell based on positi | Excel Discussion (Misc queries) | |||
Match TextBox Back Color to Cell Fill Color | Excel Programming | |||
Cell Fill Color and text color - changes for recipient | Excel Discussion (Misc queries) | |||
change fill color of a range of cells based on color of a cell? | Excel Programming |