PLEASE HELP! MACRO NEEDED

[K]

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

 

[Per Jessen]

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.