Change Color of cell

[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

 

[Claus Busch]

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

look for "Conditional Formatting"


Regards
Claus B.

 

[bong]

look for "Conditional Formatting"Danke

 

[JCO]

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