Get instant live Excel expert help with conditional formatting

I want to index match a cell, and have the conditional formatting show

I'm trying to use conditional formatting to highlight a cell in an array several columns before when the line goes less than zero. I can do this using conditional formatting by using the formula =O10<0 if I know O is the column that is in the correct position (i.e. 6 columns from the starting cell) However, if I need to calculate the column to start at, I am using =INDIRECT(H10)<0 where H10 has the starting column. This does not seem to work. Help....

I am trying to use conditional formatting based on a formula

I am working on a timeline where I am using conditional formulas to return a letter in a cell in a date column if it equals the milestone date. I am then using conditional formatting to change the letter to a shaded block on the timeline. I have a situation where there is two milestones that may be completed on one date on the timeline. For these I want to show a split shaded cell. I am struggling with the formula to show this. There are three instances in the milestone dates where two milestones can occur on a given date on the timeline. For all three instances, I need to be able to show the split shaded cell.

I have to homework problem for an IT class that I'm stuck on. Directions (15 points in total) Write a formula in each of the gold colored cells to fill them with output values. In fact, you need a single formula for each column and then to copy the fomula using AutoFill. Note that there will be no credit on output that does not result from formulas. Also note that AutoFill must produce correct outputs for all the cells in the column. If AutoFill does not work or produce correct outputs, there will be no credit. 1. (5 points) Calculate the difference between two dates and display the number of years in the "Years" column for each employee. You must include the address of the current date given by the "Current Date" in L2 2. (10 points) Use a formula with the IF function to fill in the "Benefits" column for each employee. You must use the "Benefits Table" to produce appropriate benefit code based on the number of years of work. 1. (2 pts) Sort by Category in ascending order (A to Z) 2. (3 pts) Use conditional formatting to add data bar to the data in the Sold column 3. (3 pts) Show subtotals for InStock, Sold, Revenue for each category 4. (2 pts) Format the revenue as currency (e.g., 12345 to $12.345.00) I'm confused on how to do these problems

Hi there. I'd rather not share my spreadsheet, but I'm hoping that you'll be able to assist me still. I'm working with conditional formatting and have my sheet set to format on text (Vacant Ready, Occupied, and Notice). The only problem is that it's only highlighting the specific cells that say that, when I am needing the entire row to match based on the status. Does that make sense?

how do I do a conditional formatting for three different columns and 3 different conditions

Hello, I am trying to update a spreadsheet at work. It lists out parts for technicians and where they go to associate technicians to certain jobs. I have conditional formatting to show when the job is complete but it's turning into a clutter of complete jobs mixed in with jobs still in process. how do I move rows of completed jobs to a "Completed" tab beside to remove the clutter?

I have two spreadsheets exactly the same, i would like one spreadsheet to use indicators to show whether the value in each cell is higher/lower than the value in the second spreadsheet. For now i have been applying the conditional formatting indicators to every cell however this is very timely. Hope this makes sense.

Add Minimum Cost and Maximum Cost rows that are formatted similarly to row 50 (Average Cost row). Use functions to calculate the minimum and maximum costs for the systems purchased. Convert the Initial Cost data including the Average Cost, Minimum Cost, and Maximum Cost, and the Depreciated Value data from a generic number to accounting format with no decimal places. Copy the average, minimum, and maximum functions to the Depreciated Value columns. Merge and center the title “Desktop & Laptop Systems Inventory & Depreciation” above all of the columns with data. The CEO has asked you use conditional formatting to create an easy visual on the spreadsheet of any device that is near the end of its useful life. Utilize conditional formatting for all columns that contain a depreciated value of less than $500 they will appear red. Create a pie chart to show the initial cost totals by department. You may create a set of summary data to the right of the current data to use for the creation of your chart.