Change Color of cell

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
 
C

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.
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top