Add color to cell

[sburkhar]

Hi,
I need a formula to have G:3 turn green when P:3 is marked as Paid. Thanks!

 

[excel_help_101]

use Conditional Formatting
New Rule
pick "Format only cells that contain"
change to "equal to"
select the "area" or type in "paid"
then set the format

 

[John Davis]

If you could consider a macro, this will do it.

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("P3")) Is Nothing Then

    If Target.Value = "Paid" Then Range("G3").Interior.ColorIndex = 4
    If Target.Value <> "Paid" Then Range("G3").Interior.ColorIndex = xlNone

End If

End Sub

 

[sburkhar]

got it! thanks!