Forum Discussion
Solved
Excel Contitional formating
Is it possible to conditionally format a cell if that cell contains a formula.?
mgalbert515gmailcom Then I misinterpreted your question. Excel has a function ISFORMULA and you can use that in a CF rule. Something like this:
Oops, sorry.
Not quite what I'm looking for. I want to color a cell red or whatever if that cell contains a formula as apposed to a value. Cell B7 contains (=if (A1="X","Y","N") not if the cell has a value like (X).
Not quite what I'm looking for. I want to color a cell red or whatever if that cell contains a formula as apposed to a value. Cell B7 contains (=if (A1="X","Y","N") not if the cell has a value like (X).
mgalbert515gmailcom Then I misinterpreted your question. Excel has a function ISFORMULA and you can use that in a CF rule. Something like this:
- That is so cool, thanks a Bunch. This is the first time I've used this tool and it's great.
Thank you, Thank you Thank you.- The community that is.