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:
To underscore the "Yes" you've gotten from Riny_van_Eekelen here's an image that demonstrates Conditional Formatting for a series of cells, each of which has a formula like the one that appears at the top of the image, a convoluted INDIRECT function itself. In this case, the formula that appears is what's in cell A4.
And then the coloring of the text and the background in each cell so produced is based on several different values that might be present, each of which yields its own color scheme. You can create conditional formatting rules based on the value of the cell itself or based on values in other cells.
(I'll warn you that creating and applying conditional formatting rules can be tricky at times; I often find I have to go through several attempts at getting the syntax right before it works, but I can assure you that it's very possible to do what you've asked.)