Excel Conditional Formatting greyed out
up vote
7
down vote
favorite
So I have a sheet open in Excel 2013. I have come to add some conditional formatting and cannot do so due to it being greyed out.
My suspicion is that it is due to this [Group] thing. I know that shared sheets lose conditional formatting but I can't work out what the [Group] thing means or how to get rid of it.
It is normally stored on a network share but even dragging and opening locally doesn't resolve this. The sheet is not protected nor shared in Excel.
microsoft-excel microsoft-excel-2013
asked Apr 22 '15 at 9:55
Patrick
7432718
add a comment |
up vote
7
down vote
favorite
So I have a sheet open in Excel 2013. I have come to add some conditional formatting and cannot do so due to it being greyed out.
My suspicion is that it is due to this [Group] thing. I know that shared sheets lose conditional formatting but I can't work out what the [Group] thing means or how to get rid of it.
It is normally stored on a network share but even dragging and opening locally doesn't resolve this. The sheet is not protected nor shared in Excel.
microsoft-excel microsoft-excel-2013
asked Apr 22 '15 at 9:55
Patrick
7432718
add a comment |
up vote
7
down vote
favorite
up vote
7
down vote
favorite
So I have a sheet open in Excel 2013. I have come to add some conditional formatting and cannot do so due to it being greyed out.
My suspicion is that it is due to this [Group] thing. I know that shared sheets lose conditional formatting but I can't work out what the [Group] thing means or how to get rid of it.
It is normally stored on a network share but even dragging and opening locally doesn't resolve this. The sheet is not protected nor shared in Excel.
microsoft-excel microsoft-excel-2013
asked Apr 22 '15 at 9:55
Patrick
7432718
So I have a sheet open in Excel 2013. I have come to add some conditional formatting and cannot do so due to it being greyed out.
My suspicion is that it is due to this [Group] thing. I know that shared sheets lose conditional formatting but I can't work out what the [Group] thing means or how to get rid of it.
It is normally stored on a network share but even dragging and opening locally doesn't resolve this. The sheet is not protected nor shared in Excel.
microsoft-excel microsoft-excel-2013
microsoft-excel microsoft-excel-2013
asked Apr 22 '15 at 9:55
Patrick
7432718
asked Apr 22 '15 at 9:55
Patrick
7432718
asked Apr 22 '15 at 9:55
Patrick
7432718
asked Apr 22 '15 at 9:55
Patrick
7432718
asked Apr 22 '15 at 9:55
Patrick
7432718
7432718
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
up vote
9
down vote
accepted
There are multiple worksheets in this document. One of the other worksheets had a group of cells highlighted/selected. Unselecting them allowed Conditional Formatting to be accessed.
edited Apr 22 '15 at 10:04
fixer1234
17.4k144281
answered Apr 22 '15 at 9:58
Patrick
7432718
2
Thanks. You were a lifesaver. I never thought Excel could be this retarded.
– Moha
Jun 21 '17 at 13:02
add a comment |
up vote
0
down vote
In my case the Conditional Formatting was disabled because the xls file was in shared mode.
To enable Conditional Formatting, you first have to disable shared mode, go into Review, Share workbook, and unselect 'Allow changes by more than one user at the same time'.
Once you're done, you will probably want to share the workbook again.
answered Nov 21 at 13:57
fduff
12817
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
9
down vote
accepted
There are multiple worksheets in this document. One of the other worksheets had a group of cells highlighted/selected. Unselecting them allowed Conditional Formatting to be accessed.
edited Apr 22 '15 at 10:04
fixer1234
17.4k144281
answered Apr 22 '15 at 9:58
Patrick
7432718
2
Thanks. You were a lifesaver. I never thought Excel could be this retarded.
– Moha
Jun 21 '17 at 13:02
add a comment |
up vote
9
down vote
accepted
There are multiple worksheets in this document. One of the other worksheets had a group of cells highlighted/selected. Unselecting them allowed Conditional Formatting to be accessed.
edited Apr 22 '15 at 10:04
fixer1234
17.4k144281
answered Apr 22 '15 at 9:58
Patrick
7432718
2
Thanks. You were a lifesaver. I never thought Excel could be this retarded.
– Moha
Jun 21 '17 at 13:02
add a comment |
up vote
9
down vote
accepted
up vote
9
down vote
accepted
There are multiple worksheets in this document. One of the other worksheets had a group of cells highlighted/selected. Unselecting them allowed Conditional Formatting to be accessed.
edited Apr 22 '15 at 10:04
fixer1234
17.4k144281
answered Apr 22 '15 at 9:58
Patrick
7432718
There are multiple worksheets in this document. One of the other worksheets had a group of cells highlighted/selected. Unselecting them allowed Conditional Formatting to be accessed.
edited Apr 22 '15 at 10:04
fixer1234
17.4k144281
answered Apr 22 '15 at 9:58
Patrick
7432718
edited Apr 22 '15 at 10:04
fixer1234
17.4k144281
edited Apr 22 '15 at 10:04
fixer1234
17.4k144281
edited Apr 22 '15 at 10:04
fixer1234
17.4k144281
17.4k144281
answered Apr 22 '15 at 9:58
Patrick
7432718
answered Apr 22 '15 at 9:58
Patrick
7432718
answered Apr 22 '15 at 9:58
Patrick
7432718
7432718
2
Thanks. You were a lifesaver. I never thought Excel could be this retarded.
– Moha
Jun 21 '17 at 13:02
add a comment |
2
Thanks. You were a lifesaver. I never thought Excel could be this retarded.
– Moha
Jun 21 '17 at 13:02
2
2
Thanks. You were a lifesaver. I never thought Excel could be this retarded.
– Moha
Jun 21 '17 at 13:02
Thanks. You were a lifesaver. I never thought Excel could be this retarded.
– Moha
Jun 21 '17 at 13:02
add a comment |
up vote
0
down vote
In my case the Conditional Formatting was disabled because the xls file was in shared mode.
To enable Conditional Formatting, you first have to disable shared mode, go into Review, Share workbook, and unselect 'Allow changes by more than one user at the same time'.
Once you're done, you will probably want to share the workbook again.
answered Nov 21 at 13:57
fduff
12817
add a comment |
up vote
0
down vote
In my case the Conditional Formatting was disabled because the xls file was in shared mode.
To enable Conditional Formatting, you first have to disable shared mode, go into Review, Share workbook, and unselect 'Allow changes by more than one user at the same time'.
Once you're done, you will probably want to share the workbook again.
answered Nov 21 at 13:57
fduff
12817
add a comment |
up vote
0
down vote
up vote
0
down vote
In my case the Conditional Formatting was disabled because the xls file was in shared mode.
To enable Conditional Formatting, you first have to disable shared mode, go into Review, Share workbook, and unselect 'Allow changes by more than one user at the same time'.
Once you're done, you will probably want to share the workbook again.
answered Nov 21 at 13:57
fduff
12817
In my case the Conditional Formatting was disabled because the xls file was in shared mode.
To enable Conditional Formatting, you first have to disable shared mode, go into Review, Share workbook, and unselect 'Allow changes by more than one user at the same time'.
Once you're done, you will probably want to share the workbook again.
answered Nov 21 at 13:57
fduff
12817
answered Nov 21 at 13:57
fduff
12817
answered Nov 21 at 13:57
fduff
12817
answered Nov 21 at 13:57
fduff
12817
12817
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f904595%2fexcel-conditional-formatting-greyed-out%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
