It seems to be commonly known that the Get.Cell function can be used to format (shade) cells conditionally based on whether they contain a formula or just a value (explained here: http://j-walk.com/ss/excel/usertips/tip045.htm).
Can anybody figure out how to take this one step further and format cells differently depending on the nature of the formula itself? For instance, if certain rows of data are forecast over time according to a sum formula and other rows are forecasted by simply "flat-lining" (e.g. the formula in B1 is "=A1" and the formula in C1 is "=B1") can the 2 be conditionally formatted differently?
This would be very helpful to clarify large sheets used in reporting and forecasting, but surprisingly I can't seem to find info on anyone else trying to do this. Thanks for any help or suggestions you can offer!
(Get.Cell is explained in more detail on this posting:
http://www.mrexcel.com/forum/showthread.php?t=20611)
Can anybody figure out how to take this one step further and format cells differently depending on the nature of the formula itself? For instance, if certain rows of data are forecast over time according to a sum formula and other rows are forecasted by simply "flat-lining" (e.g. the formula in B1 is "=A1" and the formula in C1 is "=B1") can the 2 be conditionally formatted differently?
This would be very helpful to clarify large sheets used in reporting and forecasting, but surprisingly I can't seem to find info on anyone else trying to do this. Thanks for any help or suggestions you can offer!
(Get.Cell is explained in more detail on this posting:
http://www.mrexcel.com/forum/showthread.php?t=20611)