Conditional Formatting for Formulas

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 ?