Conditional Formatting for Formulas

M

Murat Gordeslioglu

I have an excel spreadsheet , that contains formulas and also values , I want
to highlight all cells that contain a formula using conditional formatting.
How can I do this ?
 
M

Max

Murat Gordeslioglu said:
I have an excel spreadsheet , that contains formulas and also values , I want
to highlight all cells that contain a formula using conditional formatting.
How can I do this ?
Click to expand...

Perhaps a viable alternative ..

Press F5 > Special > Check "Formulas" > OK
will select all formula cells on the sheet at one go

Then just format to taste (Format > Cells)
 
Top