Change Color of cell

  • Thread starter Thread starter bong
  • Start date Start date
B

bong

hi all

How I can change a collor of cell in formula

Example

If I have number 1 in A1 I wont that color A3 change to red.
If other case color A3 iz blue

something this
=If (A1=1;color(A3)=red;color(A3)=blue)

bong
 
Hi,

Am Tue, 29 Oct 2013 09:32:51 +0100 schrieb bong:
If I have number 1 in A1 I wont that color A3 change to red.
If other case color A3 iz blue
Click to expand...

look for "Conditional Formatting"


Regards
Claus B.
 
Sub Macro1()
'
' Macro1 Macro
'
If (Range("A1").Value = 1) Then
Range("A3").Select
With Selection.Interior
.Color = 192
End With
Else
Range("A3").Select
With Selection.Interior
.Color = 12611584
End With
End If
End Sub
 
Back
Top