Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Oct 18, 7:52*am, Barb Reinhardt
wrote: How about (not sure why you have .. instead of . either) .Cells(MatchLineNum, 22).Font.Color = xlThemeColorLight1 Still not working (with that, or any other colour). It simply doesn't change the font colour at all. I've searched this newsgroup's past answers and it appears a lot of people had issues with it. I've managed a workaround by using a select, copy, paste method instead of changing the .font.color property, but why doesn't the .font.color property work? Is it just 2007, or earlier versions as well? Travis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change font colour | Excel Discussion (Misc queries) | |||
Change font colour | Excel Discussion (Misc queries) | |||
Change Font Colour in VB Q | Excel Programming | |||
Change font colour | Excel Discussion (Misc queries) | |||
Change font colour for whole row | Excel Worksheet Functions |