View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default change font color for row...

If is was set by conditional formatting then you will need:

Range(target.Row & ":" & target.Row).FormatConditions(1).Font.ColorIndex = 3


"Mark Kubicki" wrote:

i have this line of code to change the font color of a row; however, nothing
changes... any suggestions?


thanks in advance,
mark