View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default CF to distinguish Formulas from Inputs

"Brian Ballek" wrote:
..What I actually wanted was to highlight values that *aren't* from
formulas (so all the variables in a sheet are clearly seen)


Laterally thinking ..

Press F5 Special Check "Constants" OK
selects all non-formula cells in the sheet

Press F5 Special Check "Formulas" OK
selects all formula cells in the sheet

With the above selections done in a flash, you could then easily Format
Cells to taste
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---