|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
08-19-2008, 07:50 AM
|
|||
|
|||
Format complete line off one cell
I need to be able to color the complete line due to the value of one cell.
For example: If cell A1 is greater than or equal to 4 then I need A1-G1 to be highlighted in RED. Is this possible? Thanks for any help. 
|
|
#2
08-19-2008, 08:38 AM
|
||||
|
||||
|
|
|
#3
08-19-2008, 09:22 AM
|
|||
|
|||
|
Thanks for your help. I got it to work. Do you know if it is possible to do the same thing in Macros?
|
|
#4
08-19-2008, 09:28 AM
|
||||
|
||||
|
Yes
Code:
Sub Macro1()
If Range("A1").Value > 4 Then Range("A1:G1").Interior.ColorIndex = 3 Else Range("A1:G1").Interior.ColorIndex = 0
End Sub
|
|
#5
08-19-2008, 09:37 AM
|
|||
|
|||
|
Much appreciated.
|
 |
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Exporting one column to text file | Brelin | Excel Programming | 11 | 08-21-2008 01:29 AM |
| Preserve Cell Format | maacmaac | Excel Worksheet Functions | 2 | 07-25-2008 10:41 AM |
| textbox to Cell date format issues | Panic | Excel Programming | 1 | 04-18-2008 04:06 AM |
| New line of text within a cell | jjconomy | Excel General | 0 | 02-04-2008 08:16 AM |
| Conditional Format a cell based on a range of numbers | fablhof | Excel Miscellaneous | 2 | 04-28-2007 12:39 AM |
Linear Mode
