Need Help on Excel Spreadsheet (conditional formatting)
- or -
Post a project like this3360
$30
- Posted:
- Proposals: 5
- Remote
- #666772
- Awarded
Description
Experience Level: Entry
Description of excel work: I need help creating conditional formatting for an excel spreadsheet:
If column D "Update" reads "Start", I need the corresponding cell (same row) under column F (Actual_Start) to fill in with red (this will indicate that the employee needs to fill out a start date).
If column D "Update" reads "Finish", I need the corresponding cell (same row) under column G to fill in with red (this will indicate that the employee needs to fill out a finish date).
Bonus points if you can make the red cell turn back to white when an employee fills out the date under either column F or G.
Please let me know if you can help! More work to come if you can complete these tasks.
Extra notes:
If column D "Update" reads "Start", I need the corresponding cell (same row) under column F (Actual_Start) to fill in with red (this will indicate that the employee needs to fill out a start date).
If column D "Update" reads "Finish", I need the corresponding cell (same row) under column G to fill in with red (this will indicate that the employee needs to fill out a finish date).
Bonus points if you can make the red cell turn back to white when an employee fills out the date under either column F or G.
Please let me know if you can help! More work to come if you can complete these tasks.
Extra notes:
Altay O.
100% (12)Projects Completed
19
Freelancers worked with
19
Projects awarded
50%
Last project
9 Dec 2016
United States
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