mattmexcel
Board Regular
- Joined
- Dec 5, 2007
- Messages
- 59
Hi all,
I'm using the named range 'isFormulaOM' defined as =Get.Cell(6,A1) and then using the conditional formatting formula '=left(isFormulaOM,1)="="' to conditionally format cells that have formulas in them.
However, it appears that macros need to be enabled for this to work since the get.cell function is based in Excel4.0 Macros. Is it true that macros need to be enabled for this to work?
I'd prefer to be able to conditional format formulas in a certain way so that macros don't have to be enabled. Any thoughts on how to do this?
Thanks,
Matt
I'm using the named range 'isFormulaOM' defined as =Get.Cell(6,A1) and then using the conditional formatting formula '=left(isFormulaOM,1)="="' to conditionally format cells that have formulas in them.
However, it appears that macros need to be enabled for this to work since the get.cell function is based in Excel4.0 Macros. Is it true that macros need to be enabled for this to work?
I'd prefer to be able to conditional format formulas in a certain way so that macros don't have to be enabled. Any thoughts on how to do this?
Thanks,
Matt