 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Conditional Formatting Question
I want the formattin of a series of cells to be dependent on the data in another cell. For instance, if A1 is a result of "something" then A1:A7 will all turn red. How do I get that done??  Signaturelivifivil Say $A$1 = "Something" then select A1 to A7 and enter this formula in Conditional formatting =$A$1="something" VBA Noo That worked!!! The problem I have now is that I need this to work fo more than one row. I tried using the format painter but the problem i that they all refer back to the original cell, not the cell in eac particular row Just remove the dollar signs ($) from $A$1 (A1) *before* using the format painter. SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== That worked!!! The problem I have now is that I need this to work for more than one row. I tried using the format painter but the problem is that they all refer back to the original cell, not the cell in each particular row. Signaturelivifivil ------------------------------------------------------------------------ livifivil's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36917 View this thread: http://www.excelforum.com/showthread.php?threadid=566288 Perfect, THANKS!!!
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.