Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro needed | Excel Programming | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro needed to set macro security in Excel to minimum | Excel Programming | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |