Help creating a rubric
Closed
RJoz
Posts
1
Registration date
Sunday February 25, 2018
Status
Member
Last seen
February 25, 2018
-
Feb 25, 2018 at 01:26 AM
RJoz - Feb 27, 2018 at 04:16 AM
RJoz - Feb 27, 2018 at 04:16 AM
Related:
- Help creating a rubric
- Create a snapchat account - Guide
- Create a yahoo email account for free - Guide
- How to create a bin file in windows 10 ✓ - Programming Forum
- How to create a group chat in messenger pc - Guide
- Create a hotmail account - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Feb 26, 2018 at 06:59 AM
Feb 26, 2018 at 06:59 AM
Hello RJoz,
You could try the following:-
The above code is based on Column A (or 1).
It will colour the active cell with colour index 8 (which I think is cyan) and will convert any other already coloured cell in Column A back to white (xlNone).
I hope that this helps.
Cheerio,
vcoolio.
You could try the following:-
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim c As Range If ActiveCell.Column = 1 Then For Each c In Columns(1) c.Interior.ColorIndex = xlNone ActiveCell.Interior.ColorIndex = 8 Next c End If End Sub
The above code is based on Column A (or 1).
It will colour the active cell with colour index 8 (which I think is cyan) and will convert any other already coloured cell in Column A back to white (xlNone).
I hope that this helps.
Cheerio,
vcoolio.
Feb 27, 2018 at 04:16 AM
Cheers,
R