Conditional format cells that contain reference

rewallac

New Member
Joined
Aug 21, 2009
Messages
3
I have a large excel file and would like to conditionally format only cells that contain references (i.e. =A1+A13 or =B14/5) but not all formulas (i.e. not =5+5). I have found a way to create a named function referring to =GET.CELL(48,INDIRECT("rc",FALSE)) but that returns all formulas, and I want just references.

I would prefer to do this without the use of macros as the workbook may be shared with others that may not allow macros.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,109,537
Messages
5,529,426
Members
409,876
Latest member
Akash Yadav
Top