$$Excel-Macros$$ Re: Change Cell Color when value entered

2016-05-09 Thread Maciej Piotrowicz
Hello I presume that you will paste data to this sheet. If yes I would use separate macro for colouring cells using loop above selected range (this macro can be called using event procedure worksheet_change as belowe- not tested). Private Sub Worksheet_Change(ByVal Target As Range) If Target.

$$Excel-Macros$$ Re: Change Cell Color when value entered

2016-05-07 Thread Suman
Dear all, Please help​ on below point... *Suman Kumar* On Thu, May 5, 2016 at 1:01 PM, Suman wrote: > Dear Team, > > I'm using below code to change the cell color once value entered but I'm > unable to use this for MYRNG. I tried to do this with For Each Loop but > with this loop code