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
Rookie user; need help please
New user, apologies for asking for help for IF statement with several conditions. If cell value is<7, then return "purple fill" of the cell, and if cell value is 7-8:59, then return "green fill" of the cell, and if cell value is 9-12:59, then return "yellow fill" of the cell and if cell value is 13-15:59, then return "orange fill" of the cell and if cell value is >16, then return "red fill of the cell
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?
Employee Attrition Variables
Have an excel file which indicates which employees have left or are still with the company, along with all their historical work data (job satisfaction, tenure, education, performance, etc.). What kind of analyses or functions should I run that will help find the greatest correlation or factor leading to attrition?CONTACT TRACING
Microsoft Excel @msexcel I need help with solving a problem A company runs 6 shelters in a city. Each shelter keeps a log book of login and logout times of homeless people that come to the shelter. Attached is the log data from the shelters. On 9th May 2020, Person 1 tested positive to the corona virus after leaving Shelter 3 and was immediately isolated. The company, in a bid to curb the spread of the virus in any of their shelters, decided to perform a contact tracing exercise of those that could have been exposed to Person 1. The following assumptions are made for the purpose of this exercise. The infection is only passed from person to person and cannot be transmitted from surfaces or the air. This implies that when a person leaves a place, the people that visit the place after him are not at risk. There is a 14 day period in which the infected person could be asymptomatic. The infection rate of the virus is exponential i.e. one person can infect another person, who can then in turn infect other people he comes in contact with. You have been saddled with the task of generating a report showing a list of those that have visited any of the shelters and could have been infected through person to person contact starting with the index case. Generate a routine that accepts the following parameters, and outputs the list of probable infected persons. Person infected Last Date/time he left the Shelter just before isolation Last visited Shelter before being isolated The routine should be dynamic such that slotting in different parameters would yield an accurate contact trace list.
How to insert paragraphs within a Cell in Excel
Can anyone PLEASE tell me if there is an easy way to combine Columns A and B to look like what I have in E1 and E2? I used the concatenate formula to combine the two cells but I need the Entity/Institution under the name within the cell. Some have 2 institutions and will need
