“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I have a calendar and a list next to it with jobs and start & end dates. Ideally I would like that line (job, start, and end) to be highlighted a color and when I enter a start and end date have that range highlight the same color. How do I do this

Solved by T. A. in 11 mins

Part of the data table (B14:H27) has been set up for you. Particularly, C14 links to the initial loan term assumption D9 and cells D14:H14 are set based on the loan term decrement assumption D10; B15 links to the initial annual interest rate assumption B9 and cells B16:B27 are set based on the initial interest increment assumption B10. Please complete the Data Table set up to calculate the monthly payments (as positive numbers) at different interest rates (B15:B27) and loan terms (C14:H14). Note: the data table is designed to be flexible, i.e., it will update automatically for any changes in the loan assumptions A9:D10. Use Conditional Formatting to format C15:H27 such that all the monthly payments that are higher than the maximum allowable monthly payment in N5 are in red color.

Solved by Z. Y. in 18 mins

1) In WBS tab I would like the dates to appear. H12 should be pulling in G3 due to formula "=G3" and the other cells after that have a formula to add a day.
2) Based on start date and duration I would like to fill in the cells with a certain color.

Solved by D. W. in 13 mins

I want to set the background color for my cells but don't know the right formula, for example If "processed" (color=green) or if "declined" (color =red)

Solved by V. J. in 13 mins

I am trying to have a tab change color when the Sum of a row = 0. I am using code on the tab but it appears to be confused because the value of the given cell is not 0 it is "=SUM(G4:G17)"

Solved by S. F. in 27 mins

Want to change color in cell with drop down lists

Solved by X. S. in 24 mins

I have a spreadsheet with expiration dates in a column. They are conditionally formatted to changed colors: Green for current, Yellow for coming due within 60 days, and Red for expired. I would like to create a summary cell that will either:
A) show the highest ranking status of the column. For example, if there is one red the cell will be red, if there are no reds but a yellow and greens the cell will show yellow.
Or B) count the total of each color.
The intent is to ave a quick summary of the status of due dates.

Solved by X. A. in 15 mins

Add a primary value axis title and type Number of Downloads. Add a secondary value axis title and type Percentage of Monthly Downloads. Apply Black, Text 1 font color to both value axis titles.

Solved by M. C. in 12 mins

I want to create a circle or square that will color in when I enter a percentage in the cell.

Solved by C. H. in 23 mins

Design a workbook named sales_LastNameFirstName to help you track your weekly sales commission.
Your name should list in cell A1 in an enlarged font size with a different color than the default color merged and centered across all columns used.
Display in a labeled cell your weekly base pay as a salesperson.
Display in a labeled cell the amount of commission earned the previous week.
Your company pays commission based upon the number of sales made in the week. The commission rate is then multiplied by the weekly base pay to compute commission amount. An English description is given below of commission rates. Use that data to create a lookup table placed on the workbook. Add a box border around the lookup table.
Number of Sales Commission Rate
1-9 3.0%
10-19 3.5%
20 or more 3.8%
Include column headings for date, number of sales, commission rate, commission amount, and total pay.
Format the column headings row with some border in a different color than the default color and each entry boldfaced and center-aligned in its cell.
Include five rows of data for the five business days Monday - Friday. For the first row, enter a particular Monday date and for remaining rows, add 1 to the previous date to compute the new date.
Use the VLOOKUP function to compute the commission rate for each day based on the number of sales.
Compute the commission amount from the commission rate and the base weekly pay.
Compute the total pay as the sum of base pay and commission amount.
Under the rows add a labeled cell and display the sum of commission amounts.
Use the IF function that compares commission amount earned this week to the previous week's value and reports some congratulatory message if the current amount exceeds the previous amount, and some other message otherwise. Format the message in boldface in the same font color as your name.
Use Currency format with two decimals on all money amounts.
Use Percentage format with one decimal on all percentage values.
Insert a small money-related image to the right side of the row data to fit the size of the five rows.
Rename Sheet1 appropriately and delete unused sheets.
Add a header of your name in the left side, sheet name in the middle, and current date on the right side.
Your workbook must be unique and reflect your own data and design.

Solved by S. J. in 12 mins