PC Review

Thread Tools Rate Thread

Conditional formatting

Posts: n/a
      24th Feb 2012
How do I go about telling cell q7 backgound to be RED when q6 cell is
less that zero
Reply With Quote
Posts: n/a
      24th Feb 2012
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
Target.Offset(1, 0).Interior.ColorIndex = 0
End If
End Sub

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I do a complex conditional in a conditional formatting formula Ray Stevens Microsoft Excel Discussion 7 12th Mar 2006 11:24 PM
Conditional Formatting - Can I select a select with Conditional Formatting? Greegan Microsoft Excel Worksheet Functions 5 31st Oct 2005 03:19 PM
Conditional Formatting that will display conditional data =?Utf-8?B?QnJhaW5GYXJ0?= Microsoft Excel Worksheet Functions 1 13th Sep 2005 05:45 PM
Conditional Formatting w/ Conditional Functions... using AND =?Utf-8?B?S1dHU05B?= Microsoft Excel Programming 2 16th Mar 2004 07:56 PM
Conditional, Conditional Formatting John Meyer Microsoft Excel Discussion 8 21st Dec 2003 09:37 PM




All times are GMT +1. The time now is 07:11 PM.