View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian Ballek Brian Ballek is offline
external usenet poster
 
Posts: 4
Default CF to distinguish Formulas from Inputs

Yup, that did it - Fantastic! What I actually wanted was to highlight
values that *aren't* from formulas (so all the variables in a sheet are
clearly seen) but for that I just modified the CF to

=IsFormula=False

THANKS!

T. Valko wrote:
Here's a non-VBA method

Create this named formula:

Goto InsertNameDefine
Name: IsFormula
Refers to: =GET.CELL(48,INDIRECT("RC",FALSE))
OK

Apply conditional formatting to the cells in question.
Assume this range of cells is A1:A10
Select the range A1:A10
Goto FormatConditional Formatting
Formula Is: =IsFormula
Click the Format button
Select the style(s) desired
OK out