Conditionally format a column based on the present day of the week (calculated in another cell)Background...
Ideas for 3rd eye abilities
Can I find out the caloric content of bread by dehydrating it?
Why doesn't a const reference extend the life of a temporary object passed via a function?
Is it wise to hold on to stock that has plummeted and then stabilized?
How is it possible for user's password to be changed after storage was encrypted? (on OS X, Android)
Why was the "bread communication" in the arena of Catching Fire left out in the movie?
New order #4: World
How could a lack of term limits lead to a "dictatorship?"
Are cabin dividers used to "hide" the flex of the airplane?
Was there ever an axiom rendered a theorem?
"listening to me about as much as you're listening to this pole here"
How can I fix this gap between bookcases I made?
Landlord wants to switch my lease to a "Land contract" to "get back at the city"
How to deal with fear of taking dependencies
How to manage monthly salary
What to wear for invited talk in Canada
What are the advantages and disadvantages of running one shots compared to campaigns?
aging parents with no investments
Why is my log file so massive? 22gb. I am running log backups
Need help identifying/translating a plaque in Tangier, Morocco
Does bootstrapped regression allow for inference?
Could a US political party gain complete control over the government by removing checks & balances?
Why airport relocation isn't done gradually?
Could Giant Ground Sloths have been a good pack animal for the ancient Mayans?
Conditionally format a column based on the present day of the week (calculated in another cell)
Background colors in Excel 2010How do you have a conditional formatting rule in Excel apply to a discontiguous range of cells?Format entire row in Excel Table if row is emptyExcel 2013 - combine conditional formattingConditional formatting if an input cell is blank in a row marked completedConditional formatting skipping zeros and alternate columnsExcel, conditionally format based on two columns being equalConditional formatting for a blank cell not working when using a formual for multiple tabs in Excel 2010Cell has text and number, but I need to count bothNeed conditional formatting on cells that already have a subtraction formula
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I am building a table for work with weekly tasks. I want today's task only to appear in bold, while other weekly tasks in gray/dimmer color so to be less evident.
I created a separated, single cell where I write =NOW(), and which returns me the day of the week in 1-7 format. (let's call this cell A1).
On the columns of interest, I tried to create a conditional formatting rule that is =A1=1. 1 would be Monday. I'd like to only format the other column if A1=1, therefore if it's Monday. But It doesn't work.
I also tried with =$A$1=1, or =$A1=1, unfortunately It doesn't works also?
Can anyone help me?
microsoft-excel worksheet-function
edited 2 days ago
Rajesh S
4,4282724
asked 2 days ago
RiccardoRiccardo
1
New contributor
Riccardo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I am building a table for work with weekly tasks. I want today's task only to appear in bold, while other weekly tasks in gray/dimmer color so to be less evident.
I created a separated, single cell where I write =NOW(), and which returns me the day of the week in 1-7 format. (let's call this cell A1).
On the columns of interest, I tried to create a conditional formatting rule that is =A1=1. 1 would be Monday. I'd like to only format the other column if A1=1, therefore if it's Monday. But It doesn't work.
I also tried with =$A$1=1, or =$A1=1, unfortunately It doesn't works also?
Can anyone help me?
microsoft-excel worksheet-function
edited 2 days ago
Rajesh S
4,4282724
asked 2 days ago
RiccardoRiccardo
1
New contributor
Riccardo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
You're asking for today's day of the week, but it sounds like that isn't really what you want. If today is Monday, you probably don't want the tasks from every Monday past and future, just today's tasks (or a specified calendar date). The approach would be similar to Rajesh S's answer, but you need to specify the appropriate condition (that answer gives you what you asked for, but I'm guessing you didn't ask for what you need). Can you clarify the question? That will help get you the answer you need, and make it clearer for other people with a similar requirement who land here.
– fixer1234
2 days ago
add a comment |
I am building a table for work with weekly tasks. I want today's task only to appear in bold, while other weekly tasks in gray/dimmer color so to be less evident.
I created a separated, single cell where I write =NOW(), and which returns me the day of the week in 1-7 format. (let's call this cell A1).
On the columns of interest, I tried to create a conditional formatting rule that is =A1=1. 1 would be Monday. I'd like to only format the other column if A1=1, therefore if it's Monday. But It doesn't work.
I also tried with =$A$1=1, or =$A1=1, unfortunately It doesn't works also?
Can anyone help me?
microsoft-excel worksheet-function
edited 2 days ago
Rajesh S
4,4282724
asked 2 days ago
RiccardoRiccardo
1
New contributor
Riccardo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I am building a table for work with weekly tasks. I want today's task only to appear in bold, while other weekly tasks in gray/dimmer color so to be less evident.
I created a separated, single cell where I write =NOW(), and which returns me the day of the week in 1-7 format. (let's call this cell A1).
On the columns of interest, I tried to create a conditional formatting rule that is =A1=1. 1 would be Monday. I'd like to only format the other column if A1=1, therefore if it's Monday. But It doesn't work.
I also tried with =$A$1=1, or =$A1=1, unfortunately It doesn't works also?
Can anyone help me?
microsoft-excel worksheet-function
microsoft-excel worksheet-function
edited 2 days ago
Rajesh S
4,4282724
asked 2 days ago
RiccardoRiccardo
1
New contributor
Riccardo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 days ago
Rajesh S
4,4282724
asked 2 days ago
RiccardoRiccardo
1
New contributor
Riccardo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 days ago
Rajesh S
4,4282724
edited 2 days ago
Rajesh S
4,4282724
edited 2 days ago
Rajesh S
4,4282724
4,4282724
asked 2 days ago
RiccardoRiccardo
1
New contributor
Riccardo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 days ago
RiccardoRiccardo
1
asked 2 days ago
RiccardoRiccardo
1
1
New contributor
Riccardo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Riccardo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Riccardo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
You're asking for today's day of the week, but it sounds like that isn't really what you want. If today is Monday, you probably don't want the tasks from every Monday past and future, just today's tasks (or a specified calendar date). The approach would be similar to Rajesh S's answer, but you need to specify the appropriate condition (that answer gives you what you asked for, but I'm guessing you didn't ask for what you need). Can you clarify the question? That will help get you the answer you need, and make it clearer for other people with a similar requirement who land here.
– fixer1234
2 days ago
add a comment |
You're asking for today's day of the week, but it sounds like that isn't really what you want. If today is Monday, you probably don't want the tasks from every Monday past and future, just today's tasks (or a specified calendar date). The approach would be similar to Rajesh S's answer, but you need to specify the appropriate condition (that answer gives you what you asked for, but I'm guessing you didn't ask for what you need). Can you clarify the question? That will help get you the answer you need, and make it clearer for other people with a similar requirement who land here.
– fixer1234
2 days ago
You're asking for today's day of the week, but it sounds like that isn't really what you want. If today is Monday, you probably don't want the tasks from every Monday past and future, just today's tasks (or a specified calendar date). The approach would be similar to Rajesh S's answer, but you need to specify the appropriate condition (that answer gives you what you asked for, but I'm guessing you didn't ask for what you need). Can you clarify the question? That will help get you the answer you need, and make it clearer for other people with a similar requirement who land here.
– fixer1234
2 days ago
You're asking for today's day of the week, but it sounds like that isn't really what you want. If today is Monday, you probably don't want the tasks from every Monday past and future, just today's tasks (or a specified calendar date). The approach would be similar to Rajesh S's answer, but you need to specify the appropriate condition (that answer gives you what you asked for, but I'm guessing you didn't ask for what you need). Can you clarify the question? That will help get you the answer you need, and make it clearer for other people with a similar requirement who land here.
– fixer1234
2 days ago
add a comment |
1 Answer
1
active
oldest
votes
Try this, will help you to fix the issue:
How it works:
- Select
L2:M11and reach to Conditional
Formatting, New Rule. - Apply this Formula:
=Weekday($L2,2)=1. - Click Format button, select an appropriate
format and finish with Ok.
N.B.
WEEKDAYFormula has many Pattern for
Weekdays , I've selected2isMonday to Saturday.- You may select any one which is applicable to
your work practice.
For rest of the Rows, which has Weekday other than Monday, you need to apply this Formula.
=Weekday($L2,2)<>1.
You get this:
Adjust cell references in Formula as needed.
answered 2 days ago
Rajesh SRajesh S
4,4282724
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
});
}
});
Riccardo is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1422173%2fconditionally-format-a-column-based-on-the-present-day-of-the-week-calculated-i%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try this, will help you to fix the issue:
How it works:
- Select
L2:M11and reach to Conditional
Formatting, New Rule. - Apply this Formula:
=Weekday($L2,2)=1. - Click Format button, select an appropriate
format and finish with Ok.
N.B.
WEEKDAYFormula has many Pattern for
Weekdays , I've selected2isMonday to Saturday.- You may select any one which is applicable to
your work practice.
For rest of the Rows, which has Weekday other than Monday, you need to apply this Formula.
=Weekday($L2,2)<>1.
You get this:
Adjust cell references in Formula as needed.
answered 2 days ago
Rajesh SRajesh S
4,4282724
add a comment |
Try this, will help you to fix the issue:
How it works:
- Select
L2:M11and reach to Conditional
Formatting, New Rule. - Apply this Formula:
=Weekday($L2,2)=1. - Click Format button, select an appropriate
format and finish with Ok.
N.B.
WEEKDAYFormula has many Pattern for
Weekdays , I've selected2isMonday to Saturday.- You may select any one which is applicable to
your work practice.
For rest of the Rows, which has Weekday other than Monday, you need to apply this Formula.
=Weekday($L2,2)<>1.
You get this:
Adjust cell references in Formula as needed.
answered 2 days ago
Rajesh SRajesh S
4,4282724
add a comment |
Try this, will help you to fix the issue:
How it works:
- Select
L2:M11and reach to Conditional
Formatting, New Rule. - Apply this Formula:
=Weekday($L2,2)=1. - Click Format button, select an appropriate
format and finish with Ok.
N.B.
WEEKDAYFormula has many Pattern for
Weekdays , I've selected2isMonday to Saturday.- You may select any one which is applicable to
your work practice.
For rest of the Rows, which has Weekday other than Monday, you need to apply this Formula.
=Weekday($L2,2)<>1.
You get this:
Adjust cell references in Formula as needed.
answered 2 days ago
Rajesh SRajesh S
4,4282724
Try this, will help you to fix the issue:
How it works:
- Select
L2:M11and reach to Conditional
Formatting, New Rule. - Apply this Formula:
=Weekday($L2,2)=1. - Click Format button, select an appropriate
format and finish with Ok.
N.B.
WEEKDAYFormula has many Pattern for
Weekdays , I've selected2isMonday to Saturday.- You may select any one which is applicable to
your work practice.
For rest of the Rows, which has Weekday other than Monday, you need to apply this Formula.
=Weekday($L2,2)<>1.
You get this:
Adjust cell references in Formula as needed.
answered 2 days ago
Rajesh SRajesh S
4,4282724
edited 2 days ago
answered 2 days ago
Rajesh SRajesh S
4,4282724
answered 2 days ago
Rajesh SRajesh S
4,4282724
answered 2 days ago
Rajesh SRajesh S
4,4282724
4,4282724
add a comment |
add a comment |
Riccardo is a new contributor. Be nice, and check out our Code of Conduct.
Riccardo is a new contributor. Be nice, and check out our Code of Conduct.
Riccardo is a new contributor. Be nice, and check out our Code of Conduct.
Riccardo is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1422173%2fconditionally-format-a-column-based-on-the-present-day-of-the-week-calculated-i%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
You're asking for today's day of the week, but it sounds like that isn't really what you want. If today is Monday, you probably don't want the tasks from every Monday past and future, just today's tasks (or a specified calendar date). The approach would be similar to Rajesh S's answer, but you need to specify the appropriate condition (that answer gives you what you asked for, but I'm guessing you didn't ask for what you need). Can you clarify the question? That will help get you the answer you need, and make it clearer for other people with a similar requirement who land here.
– fixer1234
2 days ago