Cell to auto populate with colour when data is entered in another cell
- or -
Post a project like this3524
$$
- Posted:
- Proposals: 3
- Remote
- #548856
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
I have a spreadsheet that tracks marketing activity on a month by month basis. In this spreadsheet are 2 columns, one for the start date and one for the end date of the activity. Next to these 2 columns is a calendar monthly view, with each cell representing a calendar day.
When I enter the start date and end date into the spreadsheet, I need the corresponding dates in the adjacent calendar to auto populate with a colour block, to serve as a visual representation of the start and end date. This is so I don't have to manually colour in each cell in the calendar to represent the entered dates.
I've tried data bars, but that isn't working at all.
I've added a screenshot of the spreadsheet so you can see what I'm referring to.
Can you help? If you can, I have a tight deadline and need this solving today if possible. Please let me know if this will be possible along with your quote.
When I enter the start date and end date into the spreadsheet, I need the corresponding dates in the adjacent calendar to auto populate with a colour block, to serve as a visual representation of the start and end date. This is so I don't have to manually colour in each cell in the calendar to represent the entered dates.
I've tried data bars, but that isn't working at all.
I've added a screenshot of the spreadsheet so you can see what I'm referring to.
Can you help? If you can, I have a tight deadline and need this solving today if possible. Please let me know if this will be possible along with your quote.
Christian B.
0% (0)Projects Completed
3
Freelancers worked with
2
Projects awarded
75%
Last project
1 Sep 2015
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies