How do I go about telling cell q7 backgound to be RED when q6 cell is
less that zero
Thanks

Put the following code with the worksheet.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$Q$6" And Target < 0 Then
Target.Offset(1, 0).Interior.ColorIndex = 3
Else
Target.Offset(1, 0).Interior.ColorIndex = 0
End If
End Sub

Hi
If u r using Office 2007 onwards
use the conditional format
Select conditional format
Select new rule
Select use a formula to determine which cell to format
then in the formula bar just as example
Cell d4 is selected
in the formula bar click on cell c4<0
format fill red color
Thanks may this help

Bakar