How do I make excel change the colour of a cell depending on a different cells date?
Hi, How do I make excel change the colour of a cell depending on a different cells date? Turn A2 red if - E2 cell is smaller than todays date Turn A2 yellow with red outline if - E2 cell is equal to todays date Turn A2 clear if - E2 cell is bigger than the current date
Creating Multiple Timelines on in one Chart.
I am creating multiple timelines in one Chart. 1) I have the 3 series as three separate lines with the dates as a separate line at the bottom. I deleted all the lines dropping down to the main line/axis. 2) However, at some point, the dates at the bottom stopped reflecting the range I specified. 3) Also, I would like the label to be the actual task text. I can only get the series name and task date to show. If you can assist in remedying these issues, it would be much appreciated.
What function use to answer this question
Hi folks, I am preparing for Excel exam MOS 2016, while I was practicing using a demo exercise, I saw this question, which I am not happy with the way the answered it. Insert a formula into cell G4 that evaluates whether the amount is Parts, Accessories or Services exceed the Quarterly Goal. For each column that exceeds the goal apply the Quarterly Bouns Rate Please I need to know what is the best answer according to the MOS exam team.
Anyone know how to make a dropdown list dependent on the contents of 2 other dropdowns?
I'm trying to create a form with Province, City, District dropdowns being dependent on each other. I was able to create the dropdown for the provinces and make city dropdown only populate cities within the selected province, but when it comes to districts in the province/city combination i cant seem to get results. Can anyone help?
Sum returns 0
I have a data validation list in column C. In column D I have this formula: =IF(OR(C$5:C$30="400 Confirmation Calls",C$5:C$30="1100 Inbound Calls",C$5:C$30="430 Appts Created"),1,"")&IF(OR(C$5:C$30="420 Confirmation Calls",C$5:C$30="1200 Inbound Calls",C$5:C$30="450 Appts Created"),2,"")&IF(OR(C$5:C$30="450 Confirmation Calls",C$5:C$30="1300 Inbound Calls",C$5:C$30="470 Appts Created"),3,"") At the bottom of column D I want it to sum up the total for all of D and for some reason it just returns "0".
