View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Elena Elena is offline
external usenet poster
 
Posts: 43
Default setting background

I want to set the background of a cell in Excel depending on a condition.
I've tried two methods:

If intVal = 3 Then
CDRLWs.Range("a1").Font.Background = 3
End If

If intVal = 3 Then
CDRLWs.Range("a1").Font.Background = "Red"
End If

Neither are working.

Any suggestions?

Thanks in Advance!
~Elena