View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Conditional Formatting for Formulas

"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
---