How do I only calculate cells which have a filled color format?

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

worksheet cells fill with color after typing 3
send color filled shape behind text 3
How to Color a Cell Based on a Range of Cells with Colors 1
Mandatory cells only if another cell is filled 0
How to blank the colored cells? 0
How do I format a cell based on conditions in five different cells 1
How can I reffer a cell format from other cell? 1
word match in string text in cell, color format cell 1

Top