Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
font color change
I'm trying to have excel change the font color in one cell based on the font
color change in another cell. I have a macro that will do this but I would like to have it occur right after the original font color is changed (possibly a sheet macro). My macro is: If Workbooks ("Manual Entry Numbers.xls").Sheets("Sheet1").Range("E17").Font.C olorIndex = 3 Then Range("G17").Font.ColorIndex =3 If Range("J18").Font.ColorIndex = 3 Then Range("G18").Font.ColorIndex =3 (this repeats several times) End If Any Ideas would be greatly appreciated Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
Cannot change font color or cell color | Excel Discussion (Misc queries) | |||
Change in font and color | New Users to Excel | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) |