View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Utkarsh Utkarsh is offline
external usenet poster
 
Posts: 18
Default detecting formula containing a constant

Hi

Is there a way to detect formula on a sheet that contain a constant?
For example if a sheet contains formulas like

=A1*10 or =A1+10

Then I would like to change the font color of those cells to red to
flag them.

Utkarsh