Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Recolor Cell based on Sum of Zero
I have three cells. Value A, Value B, and a Sum or Total Cell, Value C. C is
calculated by adding/subtracting A & B. If the result in C is zero, I want to format that cell so it is automatically recolored to yellow. How do I do that? |
#2
|
|||
|
|||
Hi
you'll need to use conditional formatting to do this click on the C cell and choose format / conditional formatting choose cell value is choose equal to type a 0 click on format ... choose your formating, press OK twice Cheers JulieD "Cloudburst99" wrote in message ... I have three cells. Value A, Value B, and a Sum or Total Cell, Value C. C is calculated by adding/subtracting A & B. If the result in C is zero, I want to format that cell so it is automatically recolored to yellow. How do I do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help: Contingency based fee formula / cashflow analysis | Excel Discussion (Misc queries) | |||
Is it possible to use the sumif function based on the criteria of. | Excel Worksheet Functions | |||
changing value of a cell based on another cell color | Excel Discussion (Misc queries) | |||
Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
formula based on format | Excel Discussion (Misc queries) |