Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
-Hello,
What is the macro for changing the font color in a specific range based on the text entered? For instance, if user types in "Completed" into any cell in range B7:B175 the cell with completed should change the text color to green. I already have 3 allowable conditional formats in place so I need to write two more macros so I cover all 5 scenarios. Thanks, BearsFan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Font color changing by itself | Excel Discussion (Misc queries) | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
Changing Font Color | Excel Discussion (Misc queries) | |||
Changing the font color using VBA | Excel Programming | |||
Changing Font Color | Excel Programming |