| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting Based on If and Or | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on other cells | Excel Worksheet Functions | |||
| Conditional formatting based on category | Charts and Charting in Excel | |||
Linear Mode
