Titus,

Copy the code below, right-click on the worksheet tab, select "View Code", and paste the code in the
window that appears.

HTH,
Bernie
MS Excel MVP

Private Sub Worksheet_Change(ByVal Target As Range)
ColorNoFormulasAllCells
End Sub


"titushanke" wrote in message
...

Hi Bernie,
thanks for your quick reply!

Actually, the "Sub ColorNoFormulasAllCells()" is exactly what I was
looking for and works great!!!

How can I get Excel to apply this automatically so that I don't have to
"run" the Macro every time? Ideally, anytime somebody overwrites a
formula with a manual input, the cell should be highlighted
immediately. How can I accomplish this?

NB: I know that I could protect all the cells from manual input, but
for the stuff I am working on I WANT people to overwrite formulas with
their own values, just that I want to visualize it..

Thanks for all your help!!!
Highly appreciate it!


--
titushanke
------------------------------------------------------------------------
titushanke's Profile: http://www.excelforum.com/member.php...o&userid=19997
View this thread: http://www.excelforum.com/showthread...hreadid=469193