Text box conditional formatting coloring
up vote
0
down vote
favorite
I've worked out that I can link a text box to a cell. (Create the text box, add text, replace text with an equals sign =, and then click on the cell I want it to reference. So far so good.
However it does seem that I am unable to change the colour of the ink in the text box to match the conditional formatting in the cell, it always seem to default to black.
I don't want to use macros. Is there a way for the text box to reflect the colour on the text in the cell (with the conditional formatting) is referencing?
microsoft-excel text-formatting
edited Aug 21 '17 at 12:06
DavidPostill♦
102k25219255
asked Aug 21 '17 at 9:44
Mr Mystery Guest
10827
add a comment |
up vote
0
down vote
favorite
I've worked out that I can link a text box to a cell. (Create the text box, add text, replace text with an equals sign =, and then click on the cell I want it to reference. So far so good.
However it does seem that I am unable to change the colour of the ink in the text box to match the conditional formatting in the cell, it always seem to default to black.
I don't want to use macros. Is there a way for the text box to reflect the colour on the text in the cell (with the conditional formatting) is referencing?
microsoft-excel text-formatting
edited Aug 21 '17 at 12:06
DavidPostill♦
102k25219255
asked Aug 21 '17 at 9:44
Mr Mystery Guest
10827
Depends on how your text box is positioned. There maybe a way to change the background color of the textbox, but not the text. But the method I have in mind will raise the question of the requirement of the textbox. You could position the text box aligned over some cells, put the conditional formatting on the cells, keep the background color of the textbox transparent. This way the text box will reflect the background cells color.
– Firee
Aug 21 '17 at 12:22
@Firee Thanks, but I already thought of that. The textbox is part of a chart and that is likely to get moved (by a third party), so any location based ideas are off the cards.
– Mr Mystery Guest
Aug 21 '17 at 12:28
@Máté Juhász I like your candour!
– Mr Mystery Guest
Aug 21 '17 at 12:29
Did you check the camera function?
– Firee
Aug 21 '17 at 12:34
@Firee That's a good idea, but I need the colour to change depending on the values (green - low, amber - middle, red - high) And you can only apply one style to a camera picture
– Mr Mystery Guest
Aug 21 '17 at 13:20
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I've worked out that I can link a text box to a cell. (Create the text box, add text, replace text with an equals sign =, and then click on the cell I want it to reference. So far so good.
However it does seem that I am unable to change the colour of the ink in the text box to match the conditional formatting in the cell, it always seem to default to black.
I don't want to use macros. Is there a way for the text box to reflect the colour on the text in the cell (with the conditional formatting) is referencing?
microsoft-excel text-formatting
edited Aug 21 '17 at 12:06
DavidPostill♦
102k25219255
asked Aug 21 '17 at 9:44
Mr Mystery Guest
10827
I've worked out that I can link a text box to a cell. (Create the text box, add text, replace text with an equals sign =, and then click on the cell I want it to reference. So far so good.
However it does seem that I am unable to change the colour of the ink in the text box to match the conditional formatting in the cell, it always seem to default to black.
I don't want to use macros. Is there a way for the text box to reflect the colour on the text in the cell (with the conditional formatting) is referencing?
microsoft-excel text-formatting
microsoft-excel text-formatting
edited Aug 21 '17 at 12:06
DavidPostill♦
102k25219255
asked Aug 21 '17 at 9:44
Mr Mystery Guest
10827
edited Aug 21 '17 at 12:06
DavidPostill♦
102k25219255
asked Aug 21 '17 at 9:44
Mr Mystery Guest
10827
edited Aug 21 '17 at 12:06
DavidPostill♦
102k25219255
edited Aug 21 '17 at 12:06
DavidPostill♦
102k25219255
edited Aug 21 '17 at 12:06
DavidPostill♦
102k25219255
102k25219255
asked Aug 21 '17 at 9:44
Mr Mystery Guest
10827
asked Aug 21 '17 at 9:44
Mr Mystery Guest
10827
asked Aug 21 '17 at 9:44
Mr Mystery Guest
10827
10827
Depends on how your text box is positioned. There maybe a way to change the background color of the textbox, but not the text. But the method I have in mind will raise the question of the requirement of the textbox. You could position the text box aligned over some cells, put the conditional formatting on the cells, keep the background color of the textbox transparent. This way the text box will reflect the background cells color.
– Firee
Aug 21 '17 at 12:22
@Firee Thanks, but I already thought of that. The textbox is part of a chart and that is likely to get moved (by a third party), so any location based ideas are off the cards.
– Mr Mystery Guest
Aug 21 '17 at 12:28
@Máté Juhász I like your candour!
– Mr Mystery Guest
Aug 21 '17 at 12:29
Did you check the camera function?
– Firee
Aug 21 '17 at 12:34
@Firee That's a good idea, but I need the colour to change depending on the values (green - low, amber - middle, red - high) And you can only apply one style to a camera picture
– Mr Mystery Guest
Aug 21 '17 at 13:20
add a comment |
Depends on how your text box is positioned. There maybe a way to change the background color of the textbox, but not the text. But the method I have in mind will raise the question of the requirement of the textbox. You could position the text box aligned over some cells, put the conditional formatting on the cells, keep the background color of the textbox transparent. This way the text box will reflect the background cells color.
– Firee
Aug 21 '17 at 12:22
@Firee Thanks, but I already thought of that. The textbox is part of a chart and that is likely to get moved (by a third party), so any location based ideas are off the cards.
– Mr Mystery Guest
Aug 21 '17 at 12:28
@Máté Juhász I like your candour!
– Mr Mystery Guest
Aug 21 '17 at 12:29
Did you check the camera function?
– Firee
Aug 21 '17 at 12:34
@Firee That's a good idea, but I need the colour to change depending on the values (green - low, amber - middle, red - high) And you can only apply one style to a camera picture
– Mr Mystery Guest
Aug 21 '17 at 13:20
Depends on how your text box is positioned. There maybe a way to change the background color of the textbox, but not the text. But the method I have in mind will raise the question of the requirement of the textbox. You could position the text box aligned over some cells, put the conditional formatting on the cells, keep the background color of the textbox transparent. This way the text box will reflect the background cells color.
– Firee
Aug 21 '17 at 12:22
Depends on how your text box is positioned. There maybe a way to change the background color of the textbox, but not the text. But the method I have in mind will raise the question of the requirement of the textbox. You could position the text box aligned over some cells, put the conditional formatting on the cells, keep the background color of the textbox transparent. This way the text box will reflect the background cells color.
– Firee
Aug 21 '17 at 12:22
@Firee Thanks, but I already thought of that. The textbox is part of a chart and that is likely to get moved (by a third party), so any location based ideas are off the cards.
– Mr Mystery Guest
Aug 21 '17 at 12:28
@Firee Thanks, but I already thought of that. The textbox is part of a chart and that is likely to get moved (by a third party), so any location based ideas are off the cards.
– Mr Mystery Guest
Aug 21 '17 at 12:28
@Máté Juhász I like your candour!
– Mr Mystery Guest
Aug 21 '17 at 12:29
@Máté Juhász I like your candour!
– Mr Mystery Guest
Aug 21 '17 at 12:29
Did you check the camera function?
– Firee
Aug 21 '17 at 12:34
Did you check the camera function?
– Firee
Aug 21 '17 at 12:34
@Firee That's a good idea, but I need the colour to change depending on the values (green - low, amber - middle, red - high) And you can only apply one style to a camera picture
– Mr Mystery Guest
Aug 21 '17 at 13:20
@Firee That's a good idea, but I need the colour to change depending on the values (green - low, amber - middle, red - high) And you can only apply one style to a camera picture
– Mr Mystery Guest
Aug 21 '17 at 13:20
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
accepted
No. There is no way for that without macros.
answered Aug 21 '17 at 12:12
Máté Juhász
14.1k63150
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
No. There is no way for that without macros.
answered Aug 21 '17 at 12:12
Máté Juhász
14.1k63150
add a comment |
up vote
1
down vote
accepted
No. There is no way for that without macros.
answered Aug 21 '17 at 12:12
Máté Juhász
14.1k63150
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
No. There is no way for that without macros.
answered Aug 21 '17 at 12:12
Máté Juhász
14.1k63150
No. There is no way for that without macros.
answered Aug 21 '17 at 12:12
Máté Juhász
14.1k63150
answered Aug 21 '17 at 12:12
Máté Juhász
14.1k63150
answered Aug 21 '17 at 12:12
Máté Juhász
14.1k63150
answered Aug 21 '17 at 12:12
Máté Juhász
14.1k63150
14.1k63150
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%2f1242926%2ftext-box-conditional-formatting-coloring%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
Depends on how your text box is positioned. There maybe a way to change the background color of the textbox, but not the text. But the method I have in mind will raise the question of the requirement of the textbox. You could position the text box aligned over some cells, put the conditional formatting on the cells, keep the background color of the textbox transparent. This way the text box will reflect the background cells color.
– Firee
Aug 21 '17 at 12:22
@Firee Thanks, but I already thought of that. The textbox is part of a chart and that is likely to get moved (by a third party), so any location based ideas are off the cards.
– Mr Mystery Guest
Aug 21 '17 at 12:28
@Máté Juhász I like your candour!
– Mr Mystery Guest
Aug 21 '17 at 12:29
Did you check the camera function?
– Firee
Aug 21 '17 at 12:34
@Firee That's a good idea, but I need the colour to change depending on the values (green - low, amber - middle, red - high) And you can only apply one style to a camera picture
– Mr Mystery Guest
Aug 21 '17 at 13:20