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.
I would prefer to do this without the use of macros as the workbook may be shared with others that may not allow macros.
