Change Color of cell
 

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

Change Color of cell
 

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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Change Color of cell
 

look for "Conditional Formatting"

Danke

Change Color of cell
 

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


"Claus Busch" wrote in message
...
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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2