Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can someone help me determine what is wrong with the following code.
I am needing to change the color of the text in a cell to red if the cell is 100%. My code I have currently is follows. Sub Red() Range("F9:G9").Select If ActiveCell.Value 100 Then ActiveCell.Font.ColorIndex = 3 End If End Sub I appreciate any help you can give me. If I am taking the wrong approach please advise. Thank You Ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting Problem | New Users to Excel | |||
formatting problem | Excel Discussion (Misc queries) | |||
csv to xls formatting problem | Excel Discussion (Misc queries) | |||
formatting problem | Excel Discussion (Misc queries) | |||
Formatting problem | Excel Discussion (Misc queries) |