Budget Identifier in ExcelExcel 2007 - Get each record by Type from Pivot TableExcel formula to copy text...
Must a tritone substitution use a dominant seventh chord?
When should a commit not be version tagged?
Is my plan for fixing my water heater leak bad?
Can this function be rewritten with a regex?
Skis versus snow shoes - when to choose which for travelling the backcountry?
What's the difference between a cart and a wagon?
How to count words in a line
Hacker Rank: Array left rotation
Creature spells vs. ability to convert a permanent into a creature
If a druid in Wild Shape swallows a creature whole, then turns back to her normal form, what happens?
Most significant research articles for practical investors with research perspectives
Compare four integers, return word based on maximum
Waiting for the gravy at a dinner table
How to properly claim credit for peer review?
What is a term for a function that when called repeatedly, has the same effect as calling once?
How to tighten battery clamp?
Find the next monthly expiration date
Why proton concentration is divided by 10⁻⁷?
What are these green text/line displays shown during the livestream of Crew Dragon's approach to dock with the ISS?
Exponential growth/decay formula: what happened to the other constant of integration?
Significance and timing of "mux scans"
What do the pedals on grand pianos do?
What type of postprocessing gives the effect of people standing out
How can I be pwned if I'm not registered on that site?
Budget Identifier in Excel
Excel 2007 - Get each record by Type from Pivot TableExcel formula to copy text from another sheet when data in sheet 1 matchesDoes AND work in Excel spreadsheet formulae using Ctrl-Shift-Enter?Representing Specific Data from a Dynamic Database (Array) in ExcelComplex referencing in excelFinding the volatile function in my Excel sheetHow can I have Excel predict when a budget runs out of money?Creating list dependencies in excelExcel Formula to calculate hours from budgetCounting occurrences of all words in excel
I am trying to find a way that I can identify in my Excel sheet when I have an employee that goes over their travel budget the estimated cost I enter for their particular ID number turns red. I only want it to identify the budget for the ID alone and not the person as people fluctuate.
microsoft-excel microsoft-excel-2016
edited 5 hours ago
Worthwelle
2,71531325
asked 8 hours ago
CSchaeubleCSchaeuble
11
New contributor
CSchaeuble 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 trying to find a way that I can identify in my Excel sheet when I have an employee that goes over their travel budget the estimated cost I enter for their particular ID number turns red. I only want it to identify the budget for the ID alone and not the person as people fluctuate.
microsoft-excel microsoft-excel-2016
edited 5 hours ago
Worthwelle
2,71531325
asked 8 hours ago
CSchaeubleCSchaeuble
11
New contributor
CSchaeuble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2
What have you already tried? Can you provide an example of what the expected output will look like in your example?
– Worthwelle
5 hours ago
add a comment |
I am trying to find a way that I can identify in my Excel sheet when I have an employee that goes over their travel budget the estimated cost I enter for their particular ID number turns red. I only want it to identify the budget for the ID alone and not the person as people fluctuate.
microsoft-excel microsoft-excel-2016
edited 5 hours ago
Worthwelle
2,71531325
asked 8 hours ago
CSchaeubleCSchaeuble
11
New contributor
CSchaeuble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I am trying to find a way that I can identify in my Excel sheet when I have an employee that goes over their travel budget the estimated cost I enter for their particular ID number turns red. I only want it to identify the budget for the ID alone and not the person as people fluctuate.
microsoft-excel microsoft-excel-2016
microsoft-excel microsoft-excel-2016
edited 5 hours ago
Worthwelle
2,71531325
asked 8 hours ago
CSchaeubleCSchaeuble
11
New contributor
CSchaeuble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 5 hours ago
Worthwelle
2,71531325
asked 8 hours ago
CSchaeubleCSchaeuble
11
New contributor
CSchaeuble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 5 hours ago
Worthwelle
2,71531325
edited 5 hours ago
Worthwelle
2,71531325
edited 5 hours ago
Worthwelle
2,71531325
2,71531325
asked 8 hours ago
CSchaeubleCSchaeuble
11
New contributor
CSchaeuble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 8 hours ago
CSchaeubleCSchaeuble
11
asked 8 hours ago
CSchaeubleCSchaeuble
11
11
New contributor
CSchaeuble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
CSchaeuble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
CSchaeuble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2
What have you already tried? Can you provide an example of what the expected output will look like in your example?
– Worthwelle
5 hours ago
add a comment |
2
What have you already tried? Can you provide an example of what the expected output will look like in your example?
– Worthwelle
5 hours ago
2
2
What have you already tried? Can you provide an example of what the expected output will look like in your example?
– Worthwelle
5 hours ago
What have you already tried? Can you provide an example of what the expected output will look like in your example?
– Worthwelle
5 hours ago
add a comment |
1 Answer
1
active
oldest
votes
- Click on the cell you want to Conditionally format.
- Goto HOME (tab) | Styles (section) | Click Conditional Formatting.
For 18b Cost or 18b Submitted Cell formatting:
- Click Highlight Cell Rules | Greater Than
- Populate Format cells that are GREATER THAN: by clicking the same row's Estimated Cost cell.
- Remove the $ from the row reference so it will be relative.
For ID cell formatting:
New Rule... | Use a formula to determine which cells to format
- Click in the Format values where this formula is true: box
- Click the Estimated cell of this ID row.
- Type < (less than symbol).
- Click either 18b Cost or 18b Submitted cell of this ID row
- Remove the $ from both row references so they will be relative.
- It should look something like this:
=$F2<$G2
- It should look something like this:
answered 4 hours ago
Ted D.Ted D.
4618
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
});
}
});
CSchaeuble 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%2f1411163%2fbudget-identifier-in-excel%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
- Click on the cell you want to Conditionally format.
- Goto HOME (tab) | Styles (section) | Click Conditional Formatting.
For 18b Cost or 18b Submitted Cell formatting:
- Click Highlight Cell Rules | Greater Than
- Populate Format cells that are GREATER THAN: by clicking the same row's Estimated Cost cell.
- Remove the $ from the row reference so it will be relative.
For ID cell formatting:
New Rule... | Use a formula to determine which cells to format
- Click in the Format values where this formula is true: box
- Click the Estimated cell of this ID row.
- Type < (less than symbol).
- Click either 18b Cost or 18b Submitted cell of this ID row
- Remove the $ from both row references so they will be relative.
- It should look something like this:
=$F2<$G2
- It should look something like this:
answered 4 hours ago
Ted D.Ted D.
4618
add a comment |
- Click on the cell you want to Conditionally format.
- Goto HOME (tab) | Styles (section) | Click Conditional Formatting.
For 18b Cost or 18b Submitted Cell formatting:
- Click Highlight Cell Rules | Greater Than
- Populate Format cells that are GREATER THAN: by clicking the same row's Estimated Cost cell.
- Remove the $ from the row reference so it will be relative.
For ID cell formatting:
New Rule... | Use a formula to determine which cells to format
- Click in the Format values where this formula is true: box
- Click the Estimated cell of this ID row.
- Type < (less than symbol).
- Click either 18b Cost or 18b Submitted cell of this ID row
- Remove the $ from both row references so they will be relative.
- It should look something like this:
=$F2<$G2
- It should look something like this:
answered 4 hours ago
Ted D.Ted D.
4618
add a comment |
- Click on the cell you want to Conditionally format.
- Goto HOME (tab) | Styles (section) | Click Conditional Formatting.
For 18b Cost or 18b Submitted Cell formatting:
- Click Highlight Cell Rules | Greater Than
- Populate Format cells that are GREATER THAN: by clicking the same row's Estimated Cost cell.
- Remove the $ from the row reference so it will be relative.
For ID cell formatting:
New Rule... | Use a formula to determine which cells to format
- Click in the Format values where this formula is true: box
- Click the Estimated cell of this ID row.
- Type < (less than symbol).
- Click either 18b Cost or 18b Submitted cell of this ID row
- Remove the $ from both row references so they will be relative.
- It should look something like this:
=$F2<$G2
- It should look something like this:
answered 4 hours ago
Ted D.Ted D.
4618
- Click on the cell you want to Conditionally format.
- Goto HOME (tab) | Styles (section) | Click Conditional Formatting.
For 18b Cost or 18b Submitted Cell formatting:
- Click Highlight Cell Rules | Greater Than
- Populate Format cells that are GREATER THAN: by clicking the same row's Estimated Cost cell.
- Remove the $ from the row reference so it will be relative.
For ID cell formatting:
New Rule... | Use a formula to determine which cells to format
- Click in the Format values where this formula is true: box
- Click the Estimated cell of this ID row.
- Type < (less than symbol).
- Click either 18b Cost or 18b Submitted cell of this ID row
- Remove the $ from both row references so they will be relative.
- It should look something like this:
=$F2<$G2
- It should look something like this:
answered 4 hours ago
Ted D.Ted D.
4618
edited 4 hours ago
answered 4 hours ago
Ted D.Ted D.
4618
answered 4 hours ago
Ted D.Ted D.
4618
answered 4 hours ago
Ted D.Ted D.
4618
4618
add a comment |
add a comment |
CSchaeuble is a new contributor. Be nice, and check out our Code of Conduct.
CSchaeuble is a new contributor. Be nice, and check out our Code of Conduct.
CSchaeuble is a new contributor. Be nice, and check out our Code of Conduct.
CSchaeuble 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%2f1411163%2fbudget-identifier-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
2
What have you already tried? Can you provide an example of what the expected output will look like in your example?
– Worthwelle
5 hours ago