Forum Discussion
Excel Contitional formating
mgalbert515gmailcom Then I misinterpreted your question. Excel has a function ISFORMULA and you can use that in a CF rule. Something like this:
mgalbert515gmailcom Have you looked here?
Let's say you want to colour a cell red if it has the value 20. It doesn't matter if the cell contains the number 20 or a formula that results in the number 20.
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).
So your question is simply "Does this cell contain a formula?"
There is a function ISFORMULA that can be used in the conditional formatting rule, as shown in the attached file. Cell A1 here contains the value 5; cell B1 contains the formula =2+3. Both have the conditional formatting rule shown, and you see the result.
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.
