Conditional formatting

[Guest]

Can I format a cell based on the "filled" color of another cell?

Also, how could add up all the cells that are formatting with a certain color?

 

[DNA]

Try looking here:

http://www.contextures.com/xlCondFormat01.html

 

[Guest]

This method does not work. You are telling me to perform a conditional
format based on the "value" of a cell, not the fill colour of the cell.

 

[Debra Dalgleish]

There's no built-in feature that will format a cell based on the colour
of another cell. Chip Pearson has information on using colours in
functions. Maybe it will help you get started:

http://www.cpearson.com/excel/colors.htm

You could use the CellColorIndex function in a hidden cell, to return
the colour of the first cell, and base the second cell's conditional
formatting on that.

 

[Guest]

I have seen this link from Chip Pearson before and I cannot make heads or
tails of it. I have no idea what a VBA function is.

 

[Dave Peterson]

You may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm