Get instant live Excel expert help to learn how to combine conditional formatting with IF statement

5. Using conditional formatting, identify the stock with least variance. Also using conditional formatting, identify the column corresponding to the stock with least variance, which are the 3 stocks whose returns have least covariance within said stocks? These 3 stocks, do they belong to the portfolio of least variance? Why or why not? 6. If someone wanted to have a return of .3%, what stocks would they need to buy and in what proportions? Know that proportions vary between [0, 1] and that the summation of the proportions is equal to 1.

Hi I have a cell in excel that i would like to use conditional formatting on. this cell would then look at 2 or more other cells in the same column to see if the value has been duplicated and then change the cell color background to orange or red if the same value is found. thankyou

Hello I would like to highlight entire row of a table if one cell in row equals yesterday. I do not know how to do it with conditional formatting.

My report has a formula that changes text in "L" column based on the date (column "K" being greater than 300 days. I want to highlight and change column "L" text if date in column "K" is greater than 30 days past date. I'm not sure if this can even be done in conditional formatting or if it will work better in VBA, Any help would be WONDERFUL! Thank you!

Conditional formatting Comparing dates in two columns, need the date to remain black if completed ahead of schedule, this conflicts with the late rule as blank cells are considered and earlier date.

I’m trying to use conditional formatting to create rules for cells to color code blue or red when values are either lesser or greater. Columns C7-17 and F7-17 are comparing to each other. Columns C24-50 and F24-50 are cells that allow my conditional formatting to work. Ultimately, cells F7-17 are color coded based on comparing to cells C7-17, with the work to allow this formatting following below. Looking at the attached, I need help formatting the cells F8, F10, and F12. Rules I’m struggling on in these three cells: F8: If value is comparing a $ figure to text None, the None cell should be blue. F10: If value is comparing None to $ value, the $ value should be red. If value is comparing % to $ value, $ value should be red.

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 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

I have a list of services for various sites within our business, some of these services are the same at different sites but have different costs. I am looking for the best way to show which services have variant costs and what they are. I have tried a range of Nested IF formula's and some basic conditional formatting but it becomes over complicated. Any assistance on how best to present this would be appreciated