PC Review


Reply
Thread Tools Rate Thread

Conditional formatting

 
 
pcorcele
Guest
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
Thanks
 
Reply With Quote
 
 
 
 
merjet
Guest
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
Else
Target.Offset(1, 0).Interior.ColorIndex = 0
End If
End Sub

 
Reply With Quote
 
 
 
Reply

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


Features
 

Advertising
 

Newsgroups
 


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