View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Conditional Formats - Forumlas

.. an alternative to highlighting the formulas

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
---
"VBA Noob" wrote:

Hi all,

I'm using the tip on the attached link to highlight cells with
formulas. At home it opens fine but at work a co-worked and I both get
a macro warning saying there was a Macro V4 on the sheet.

Does anyone know why or an alternative to highlighting the formulas

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