Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change color
Good day,
I don't know if this is possible in Excel, but I would like to change the background color of a cell as soon as it has been typed in. Is this even possible? -- Thanks for your help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change color
Try this,
Public OldRng As Range Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not OldRng Is Nothing Then OldRng.Interior.ColorIndex = 35 'Awful green, change to taste If OldRng.Value = "" Then OldRng.Interior.ColorIndex = xlNone End If Set OldRng = Target End Sub Right click the sheet tab, view code and paste in. Mike "TamIam" wrote: Good day, I don't know if this is possible in Excel, but I would like to change the background color of a cell as soon as it has been typed in. Is this even possible? -- Thanks for your help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change color
Thanks Mike! It worked, however, because I have inserted formulas throughout
the spreadsheet, I only really wanted it to change color when I typed over any given formula. This is probably not possible, but I appreciate your response, thanks again! -- Thanks for your help! "Mike H" wrote: Try this, Public OldRng As Range Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not OldRng Is Nothing Then OldRng.Interior.ColorIndex = 35 'Awful green, change to taste If OldRng.Value = "" Then OldRng.Interior.ColorIndex = xlNone End If Set OldRng = Target End Sub Right click the sheet tab, view code and paste in. Mike "TamIam" wrote: Good day, I don't know if this is possible in Excel, but I would like to change the background color of a cell as soon as it has been typed in. Is this even possible? -- Thanks for your help! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change color
I'm glad it helped and had you asked for formula then that is doable.
However, before I try I'm nervous about when I typed over any given formula Is this different than any formula? Mike "TamIam" wrote: Thanks Mike! It worked, however, because I have inserted formulas throughout the spreadsheet, I only really wanted it to change color when I typed over any given formula. This is probably not possible, but I appreciate your response, thanks again! -- Thanks for your help! "Mike H" wrote: Try this, Public OldRng As Range Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not OldRng Is Nothing Then OldRng.Interior.ColorIndex = 35 'Awful green, change to taste If OldRng.Value = "" Then OldRng.Interior.ColorIndex = xlNone End If Set OldRng = Target End Sub Right click the sheet tab, view code and paste in. Mike "TamIam" wrote: Good day, I don't know if this is possible in Excel, but I would like to change the background color of a cell as soon as it has been typed in. Is this even possible? -- Thanks for your help! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change color
No...just me being strange...I have a vlookup formula in every cell and when
I type over the formula even if it results in the same value as the formula, I wanted the cell to change...this is my struggle...I can change the colour with the conditional format cell value does not equal to, however, if I actually want the same value manually typed in as the formula would result in, I would still like to see that it has been type in...too much info I know. Thanks again Mike! You've been awesome! -- Thanks for your help! "Mike H" wrote: I'm glad it helped and had you asked for formula then that is doable. However, before I try I'm nervous about when I typed over any given formula Is this different than any formula? Mike "TamIam" wrote: Thanks Mike! It worked, however, because I have inserted formulas throughout the spreadsheet, I only really wanted it to change color when I typed over any given formula. This is probably not possible, but I appreciate your response, thanks again! -- Thanks for your help! "Mike H" wrote: Try this, Public OldRng As Range Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not OldRng Is Nothing Then OldRng.Interior.ColorIndex = 35 'Awful green, change to taste If OldRng.Value = "" Then OldRng.Interior.ColorIndex = xlNone End If Set OldRng = Target End Sub Right click the sheet tab, view code and paste in. Mike "TamIam" wrote: Good day, I don't know if this is possible in Excel, but I would like to change the background color of a cell as soon as it has been typed in. Is this even possible? -- Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you change the color of one cell based on the color of another | Excel Discussion (Misc queries) | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) | |||
Allow users to change the color of the comment indicator color so. | Excel Discussion (Misc queries) |