PLEASE HELP! MACRO NEEDED

  • Thread starter Thread starter K
  • Start date Start date
K

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
 
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.
 
Back
Top