conditional formatting

[DMcD]

Is there a way to conditionally format a cell when the cell contains a formula? This is an input cell that would normally contain a user-entered number, but I want to highlight the cell if the user has actually entered a formula.

Never mind... I just found David Hagar's previously posted solution. Problem Solved.
This message was edited by DMcD on 2002-10-30 15:04

 

[PaddyD]

always nice to post links to previous threads that solved the problem...

 

[DMcD]

PaddyD:
Great idea, but how do I do that? I stumbled on the answer under "user tips" at http://j-walk.com/ss/excel/usertips/tip045.htm

 

[PaddyD]

looks like you just did it!

paddy

 

[PaddyD]

However, there is a note of caution re using get.cell - follow aladin's link here:

http://216.92.17.166/board/viewtopic.php?topic=21312&forum=2

paddy