| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format sheet with color
How can i assign a macro to change the color of the whole sheet based on a
value? ex if b1 295 change the sheet to red? Thanks -- Brent |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format sheet with color
If Range("B1").value 295 Then
Cells.Interior.Colorindex = 2 End If or you could use conditional formatting, but it might be quite an overhead. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Brent" wrote in message ... How can i assign a macro to change the color of the whole sheet based on a value? ex if b1 295 change the sheet to red? Thanks -- Brent |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| color fill button is not adding color to my spread sheet | Excel Worksheet Functions | |||
| Cond. format text color based on another's text color | Excel Discussion (Misc queries) | |||
| CANNOT COLOR MY WORKSHEET TABS, TAB COLOR NOT IN FORMAT | Excel Worksheet Functions | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
Linear Mode
