How to permanently color a column in Excel
How do you set a column or row to always be a certain color even when adding rows or columns? If you shade/color a column normally, when you add a row or copy paste another cell into that column it will be with no fill or with the fill of the copied cell, respectively. I want column A to always be blue no matter what. Can this be achieved?
microsoft-excel microsoft-excel-2010
asked May 1 '16 at 14:02
alnafiealnafie
10816
add a comment |
How do you set a column or row to always be a certain color even when adding rows or columns? If you shade/color a column normally, when you add a row or copy paste another cell into that column it will be with no fill or with the fill of the copied cell, respectively. I want column A to always be blue no matter what. Can this be achieved?
microsoft-excel microsoft-excel-2010
asked May 1 '16 at 14:02
alnafiealnafie
10816
add a comment |
How do you set a column or row to always be a certain color even when adding rows or columns? If you shade/color a column normally, when you add a row or copy paste another cell into that column it will be with no fill or with the fill of the copied cell, respectively. I want column A to always be blue no matter what. Can this be achieved?
microsoft-excel microsoft-excel-2010
asked May 1 '16 at 14:02
alnafiealnafie
10816
How do you set a column or row to always be a certain color even when adding rows or columns? If you shade/color a column normally, when you add a row or copy paste another cell into that column it will be with no fill or with the fill of the copied cell, respectively. I want column A to always be blue no matter what. Can this be achieved?
microsoft-excel microsoft-excel-2010
microsoft-excel microsoft-excel-2010
asked May 1 '16 at 14:02
alnafiealnafie
10816
asked May 1 '16 at 14:02
alnafiealnafie
10816
asked May 1 '16 at 14:02
alnafiealnafie
10816
asked May 1 '16 at 14:02
alnafiealnafie
10816
asked May 1 '16 at 14:02
alnafiealnafie
10816
10816
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
If you place these event routines in the worksheet code area, column A will remain blue most of the time:
Private Sub Worksheet_Change(ByVal Target As Range)
Range("A:A").Interior.Color = 12611584
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A:A").Interior.Color = 12611584
End Sub
You can temporarily change a column A cell's color, but it will return to blue once you change selection.
You can override the effect by disabling Events or by disabling macros in general.
(using this technique may cause your worksheet to become sluggish.)
answered May 1 '16 at 14:15
Gary's StudentGary's Student
13.4k31729
Thanks. I was hoping for a solution without using code.
– alnafie
May 2 '16 at 7:47
add a comment |
You could try conditional formatting:
Select entire sheet.
Conditional Formatting
-> Add New Rule
-> Use a formula to determine which cells to format
Enter formula:
=IF(COLUMN(A1)=1,TRUE,FALSE)
or just
=COLUMN(A1)=1
(both the same result - just depends which syntax you feel more comfortable with)
This will check for each cell (you put A1 in because you put it in for the top-left cell of the selection, so A1 because you selected everything - it'll work itself out for the rest of the sheet accordingly)...
...whether its column number is 1 - which will only be the case for column A.
Then pick the formatting you want and click OK, and you're done.
answered May 3 '16 at 2:05
psymannpsymann
84
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1071822%2fhow-to-permanently-color-a-column-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
If you place these event routines in the worksheet code area, column A will remain blue most of the time:
Private Sub Worksheet_Change(ByVal Target As Range)
Range("A:A").Interior.Color = 12611584
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A:A").Interior.Color = 12611584
End Sub
You can temporarily change a column A cell's color, but it will return to blue once you change selection.
You can override the effect by disabling Events or by disabling macros in general.
(using this technique may cause your worksheet to become sluggish.)
answered May 1 '16 at 14:15
Gary's StudentGary's Student
13.4k31729
Thanks. I was hoping for a solution without using code.
– alnafie
May 2 '16 at 7:47
add a comment |
If you place these event routines in the worksheet code area, column A will remain blue most of the time:
Private Sub Worksheet_Change(ByVal Target As Range)
Range("A:A").Interior.Color = 12611584
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A:A").Interior.Color = 12611584
End Sub
You can temporarily change a column A cell's color, but it will return to blue once you change selection.
You can override the effect by disabling Events or by disabling macros in general.
(using this technique may cause your worksheet to become sluggish.)
answered May 1 '16 at 14:15
Gary's StudentGary's Student
13.4k31729
Thanks. I was hoping for a solution without using code.
– alnafie
May 2 '16 at 7:47
add a comment |
If you place these event routines in the worksheet code area, column A will remain blue most of the time:
Private Sub Worksheet_Change(ByVal Target As Range)
Range("A:A").Interior.Color = 12611584
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A:A").Interior.Color = 12611584
End Sub
You can temporarily change a column A cell's color, but it will return to blue once you change selection.
You can override the effect by disabling Events or by disabling macros in general.
(using this technique may cause your worksheet to become sluggish.)
answered May 1 '16 at 14:15
Gary's StudentGary's Student
13.4k31729
If you place these event routines in the worksheet code area, column A will remain blue most of the time:
Private Sub Worksheet_Change(ByVal Target As Range)
Range("A:A").Interior.Color = 12611584
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A:A").Interior.Color = 12611584
End Sub
You can temporarily change a column A cell's color, but it will return to blue once you change selection.
You can override the effect by disabling Events or by disabling macros in general.
(using this technique may cause your worksheet to become sluggish.)
answered May 1 '16 at 14:15
Gary's StudentGary's Student
13.4k31729
edited May 1 '16 at 14:21
answered May 1 '16 at 14:15
Gary's StudentGary's Student
13.4k31729
answered May 1 '16 at 14:15
Gary's StudentGary's Student
13.4k31729
answered May 1 '16 at 14:15
Gary's StudentGary's Student
13.4k31729
13.4k31729
Thanks. I was hoping for a solution without using code.
– alnafie
May 2 '16 at 7:47
add a comment |
Thanks. I was hoping for a solution without using code.
– alnafie
May 2 '16 at 7:47
Thanks. I was hoping for a solution without using code.
– alnafie
May 2 '16 at 7:47
Thanks. I was hoping for a solution without using code.
– alnafie
May 2 '16 at 7:47
add a comment |
You could try conditional formatting:
Select entire sheet.
Conditional Formatting
-> Add New Rule
-> Use a formula to determine which cells to format
Enter formula:
=IF(COLUMN(A1)=1,TRUE,FALSE)
or just
=COLUMN(A1)=1
(both the same result - just depends which syntax you feel more comfortable with)
This will check for each cell (you put A1 in because you put it in for the top-left cell of the selection, so A1 because you selected everything - it'll work itself out for the rest of the sheet accordingly)...
...whether its column number is 1 - which will only be the case for column A.
Then pick the formatting you want and click OK, and you're done.
answered May 3 '16 at 2:05
psymannpsymann
84
add a comment |
You could try conditional formatting:
Select entire sheet.
Conditional Formatting
-> Add New Rule
-> Use a formula to determine which cells to format
Enter formula:
=IF(COLUMN(A1)=1,TRUE,FALSE)
or just
=COLUMN(A1)=1
(both the same result - just depends which syntax you feel more comfortable with)
This will check for each cell (you put A1 in because you put it in for the top-left cell of the selection, so A1 because you selected everything - it'll work itself out for the rest of the sheet accordingly)...
...whether its column number is 1 - which will only be the case for column A.
Then pick the formatting you want and click OK, and you're done.
answered May 3 '16 at 2:05
psymannpsymann
84
add a comment |
You could try conditional formatting:
Select entire sheet.
Conditional Formatting
-> Add New Rule
-> Use a formula to determine which cells to format
Enter formula:
=IF(COLUMN(A1)=1,TRUE,FALSE)
or just
=COLUMN(A1)=1
(both the same result - just depends which syntax you feel more comfortable with)
This will check for each cell (you put A1 in because you put it in for the top-left cell of the selection, so A1 because you selected everything - it'll work itself out for the rest of the sheet accordingly)...
...whether its column number is 1 - which will only be the case for column A.
Then pick the formatting you want and click OK, and you're done.
answered May 3 '16 at 2:05
psymannpsymann
84
You could try conditional formatting:
Select entire sheet.
Conditional Formatting
-> Add New Rule
-> Use a formula to determine which cells to format
Enter formula:
=IF(COLUMN(A1)=1,TRUE,FALSE)
or just
=COLUMN(A1)=1
(both the same result - just depends which syntax you feel more comfortable with)
This will check for each cell (you put A1 in because you put it in for the top-left cell of the selection, so A1 because you selected everything - it'll work itself out for the rest of the sheet accordingly)...
...whether its column number is 1 - which will only be the case for column A.
Then pick the formatting you want and click OK, and you're done.
answered May 3 '16 at 2:05
psymannpsymann
84
answered May 3 '16 at 2:05
psymannpsymann
84
answered May 3 '16 at 2:05
psymannpsymann
84
answered May 3 '16 at 2:05
psymannpsymann
84
84
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1071822%2fhow-to-permanently-color-a-column-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
