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 ?

"Murat Gordeslioglu" wrote:
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 ?

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

try this site

http://j-walk.com/ss/excel/usertips/tip045.htm

"Murat Gordeslioglu" wrote:

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 ?

thanks , this is what I needed

"Nikki" wrote:

try this site

http://j-walk.com/ss/excel/usertips/tip045.htm

"Murat Gordeslioglu" wrote:

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 ?