Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
background colour.
I have some cells with background colour.
I want the background colour change automatically when the value of the cell being updated,but when printing the the sheet,the background colour is disappear. How to do that? The cell position is random. Thank's id advance. Rgds, Shiro. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
background colour.
On Mon, 21 Jul 2008 13:44:47 +0800, "shiro" wrote:
From Chip Pearson's site: Put the following code in 'thisWorkbook'. The selected cell in all your sheets will then change color, and the cell which was left will revert back to no color. Option Explicit Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range) Static OldCell As Range If Not OldCell Is Nothing Then OldCell.Interior.ColorIndex = xlColorIndexNone End If Target.Interior.ColorIndex = 6 Set OldCell = Target End Sub I have some cells with background colour. I want the background colour change automatically when the value of the cell being updated,but when printing the the sheet,the background colour is disappear. How to do that? The cell position is random. Thank's id advance. Rgds, Shiro. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
background colour.
Mr Stephen,
Appreciated your help.I have not visited Mr Chip's page, just hope I'll get the answer here. I need more condition,I want turn the OldCell colour to another colour if the cell's value was updated by user, if it's not updated the colour is xlColorIndexNone,how to modify the code? Thank's in advance. Rgds, Shiro "Stephen Newman" wrote in message ... On Mon, 21 Jul 2008 13:44:47 +0800, "shiro" wrote: From Chip Pearson's site: Put the following code in 'thisWorkbook'. The selected cell in all your sheets will then change color, and the cell which was left will revert back to no color. Option Explicit Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range) Static OldCell As Range If Not OldCell Is Nothing Then OldCell.Interior.ColorIndex = xlColorIndexNone End If Target.Interior.ColorIndex = 6 Set OldCell = Target End Sub I have some cells with background colour. I want the background colour change automatically when the value of the cell being updated,but when printing the the sheet,the background colour is disappear. How to do that? The cell position is random. Thank's id advance. Rgds, Shiro. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
How to filter using background colour? | Excel Worksheet Functions | |||
Combo box background colour | Excel Programming | |||
Background colour using VB | Excel Programming | |||
Background colour using VB | Excel Programming |