Forum Discussion
Bailey_Stiles_Epiroc
Aug 24, 2021Copper Contributor
Differentiating between a Formula and Hard Entered (Static) Data - Excel
I have the problem of trying to conditional format a cell based upon whether the contents of each cell are hard entered (static) data or if there is a formula in the cell. Example of this is when I...
HansVogelaar
Aug 24, 2021MVP
I don't understand what you want (and your tables have switched the row numbers and column letters), but you could create rules of type 'Use a formula to determine which cells to format'. In the formula for the rule, you can use the ISFORMULA function.
ISFORMULA(B2) will return TRUE if B2 contains a formula and FALSE if it doesn't.