Conditional values based on formatting?
 

Hello,

I'd like to have Excel create a value based on a formula in a cell, if that
cell is highlighted/filled. It's kind of the inverse of conditional
formatting.

For instance, I'm setting up a spreadsheet to track who is involved in
various activities. I'd like to set it up so that if I fill a cell with
yellow, and that cell contains a "dormant" equation that equals zero
otherwise, that cell automatically performs the calculation to create a value.

Is this possible? Thank you!

Conditional values based on formatting?
 

You can employ Chip Pearson's CellColorIndex UDF in your formula.

=IF(cellcolorindex(C1)=6,"",B1*B2) entered in C1

Chip's site..............

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


Gord Dibben MS Excel MVP


On Tue, 22 May 2007 08:58:06 -0700, lerjia
wrote:

Hello,

I'd like to have Excel create a value based on a formula in a cell, if that
cell is highlighted/filled. It's kind of the inverse of conditional
formatting.

For instance, I'm setting up a spreadsheet to track who is involved in
various activities. I'd like to set it up so that if I fill a cell with
yellow, and that cell contains a "dormant" equation that equals zero
otherwise, that cell automatically performs the calculation to create a value.

Is this possible? Thank you!

Conditional values based on formatting?
 

Thank you, Gord! that's pretty cool...

"Gord Dibben" wrote:

You can employ Chip Pearson's CellColorIndex UDF in your formula.

=IF(cellcolorindex(C1)=6,"",B1*B2) entered in C1

Chip's site..............

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


Gord Dibben MS Excel MVP


On Tue, 22 May 2007 08:58:06 -0700, lerjia
wrote:

Hello,

I'd like to have Excel create a value based on a formula in a cell, if that
cell is highlighted/filled. It's kind of the inverse of conditional
formatting.

For instance, I'm setting up a spreadsheet to track who is involved in
various activities. I'd like to set it up so that if I fill a cell with
yellow, and that cell contains a "dormant" equation that equals zero
otherwise, that cell automatically performs the calculation to create a value.

Is this possible? Thank you!