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" <titushanke.1vpbmc_1127293529.2203@excelforum-nospam.com> wrote in message
news:titushanke.1vpbmc_1127293529.2203@excelforum-nospam.com...
>
> 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
>