Need Help on Excel Spreadsheet (conditional formatting)

  • Posted:
  • Proposals: 6
  • Remote
  • #666772
  • Awarded
Stephen H.
ExcelStudioWorks A.Dhishna C.Excel S.Tony S. + 1 other have already sent a proposal.
  • 1

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:

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.