Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA change font color if existing cell value changes
Hi,
I have found a macro on the net and edited so that if an exisiting cell value is changed the font will change to red. However, I am trying to amend this code so that it refers to an entire column and not just a cell. I am very new to VB and have not found a way. Can someone help me amend this code or know a better way of doing this. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = ("$A$2") Then Range("A2").Font.Color = RGB(255, 0, 0) End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot change font color or cell color | Excel Discussion (Misc queries) | |||
change font color depending on cell value | Excel Worksheet Functions | |||
Reg. Change of font color in a cell | Excel Worksheet Functions | |||
Change font color in cell | Excel Discussion (Misc queries) | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) |