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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA change font color if existing cell value changes
You didn't tells, so assuming the column you want to change is Column A...
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$2" Then Range("A2").EntireColumn.Font.Color = RGB(255, 0, 0) End If End Sub -- Rick (MVP - Excel) wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA change font color if existing cell value changes
On Jan 30, 6:47*pm, "Rick Rothstein"
wrote: You didn't tells, so assuming the column you want to change is Column A.... Private Sub Worksheet_Change(ByVal Target As Range) * * If Target.Address = "$A$2" Then * * * * Range("A2").EntireColumn.Font.Color = RGB(255, 0, 0) * * End If End Sub -- Rick (MVP - Excel) wrote in message ... 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 Hi Rick, My column is A. However, I am not sure if this adjustment is doing what it needs to. My range is in column A (not just A2) and if any cell is changed in A then I need the cell to change the font colour. Is there a way to do this? Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA change font color if existing cell value changes
The Range("A2").EntireColumn properties returns a range referring to the
whole column containing A2, that means olumn A " wrote: On Jan 30, 6:47 pm, "Rick Rothstein" wrote: You didn't tells, so assuming the column you want to change is Column A.... Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$2" Then Range("A2").EntireColumn.Font.Color = RGB(255, 0, 0) End If End Sub -- Rick (MVP - Excel) wrote in message ... 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 Hi Rick, My column is A. However, I am not sure if this adjustment is doing what it needs to. My range is in column A (not just A2) and if any cell is changed in A then I need the cell to change the font colour. Is there a way to do this? Thanks! |
Reply |
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) |