G
Guest
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!
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!