Highlight Cells Containing Formulas with Conditional Formatting

[Hydestone]

Is there a way to use conditional formatting to identify which cells contain formulas?

 

[RoryA]

Yes there is, but is there a reason you need it to be dynamic?

 

[Hydestone]

Various people will be using the spreadsheet...just easier than 'go to special' from menu.

 

[RoryA]

OK. Define a name called HasFormula using:

=GET.CELL(48,INDIRECT("RC",0))

as the formula.

Then in your CF dialog, choose use a formula to determine which cells to format and use:

=HasFormula

as the formula and apply whatever formatting you want. You will then have to save the file as a macro enabled file, if it isn't already one.