PLEASE HELP! MACRO NEEDED
 

Hi all, I need macro in worksheet module for when ever value is
entered in any
cell of Range("G3:G50000") then macro should colour that cell row
from
column A to column J in yellow. Please can any friend help

PLEASE HELP! MACRO NEEDED
 

Hi

If column G cells are empty by default, and you want the entire row to
turn yellow when user enter a value in column G, it can be done with
conditional formatting.

Select range A3:J50000 and goto Format Conditional Formatting
Condition 1: Formula is =$G3<"" Format as desired.

Hopes this helps.

---
Per

On 20 Jun., 13:13, K wrote:
Hi all, *I need macro in worksheet module for when ever value is
entered in any
cell of Range("G3:G50000") then macro should colour that cell row
from
column A to column J in yellow. *Please can any friend help