Conditional formatting-Can I format a cell based on the "filled" color of another cel

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?

Try looking here:

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

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.

"DNA" wrote:

> Try looking here:
>
> http://www.contextures.com/xlCondFormat01.html
>
>

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.

Phillip Bruce wrote:
> 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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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.

"Debra Dalgleish" wrote:

> 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.
>
> Phillip Bruce wrote:
> > 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?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

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

Phillip Bruce wrote:
>
> 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.
>
> "Debra Dalgleish" wrote:
>
> > 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.
> >
> > Phillip Bruce wrote:
> > > 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?
> >
> >
> > --
> > Debra Dalgleish
> > Excel FAQ, Tips & Book List
> > http://www.contextures.com/tiptech.html
> >
> >

--

Dave Peterson