Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I only calculate cells which have a filled color format?
I am using Microsoft Office Excel 2003. I am looking for a way to format a
cell based upon another cell's format. For instance, if cell A2 has been filled with a color, then cell F2 should be filled with the same color. I looked under conditional formats and the only "conditions" are for a cell having a "value" or "formula." There is nothing about whether the cell contains a certain "format." Also, one I have all the cells identified as being filled, I need to be able to sum all the "colored" cells that are found in a specific range. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return number of cells filled | New Users to Excel | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
calculate percentage of two cells | Excel Worksheet Functions | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
calculate the sum of cells where values are between 6 and 10 in e. | Excel Worksheet Functions |