COlor change macro
Closed
Rommy
-
Jan 21, 2011 at 10:17 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 22, 2011 at 12:18 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 22, 2011 at 12:18 AM
Related:
- COlor change macro
- Notepad++ change background color - Guide
- Change computer name cmd - Guide
- Rj45 color - Guide
- How to change crosshair color csgo - Guide
- T-mobile change number - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 22, 2011 at 12:18 AM
Jan 22, 2011 at 12:18 AM
open vb editor alt+F11 and hit control+R
in the project window right click shee1 of YOUR FILE
click view code and copy this event code
type in any cell red and see what happens to that cell
try few more colors and some other cells
I do not what u mean by orange. find the number and add that case statement within the event code
in the project window right click shee1 of YOUR FILE
click view code and copy this event code
Private Sub Worksheet_Change(ByVal Target As Range) Dim r As String Target.Interior.ColorIndex = xlNone Select Case Target Case "red" Target.Interior.ColorIndex = 3 Case "purple" Target.Interior.ColorIndex = 7 Case "yellow" Target.Interior.ColorIndex = 6 Case "green" Target.Interior.ColorIndex = 4 Case "blue" Target.Interior.ColorIndex = 5 End Select End Sub
type in any cell red and see what happens to that cell
try few more colors and some other cells
I do not what u mean by orange. find the number and add that case statement within the event code
