Format cells in Excel base on multiple conditions

  • Posted:
  • Proposals: 1
  • Remote
  • #2423559
  • Awarded
Manish K.
has already sent a proposal.
  • 0

Description

Experience Level: Entry
Estimated project duration: 1 day or less
I have a excel spreadsheet containing data of stock movement - Stock In and Stock Out

Stock In - can be via two Transaction Type - which is Adjustment or Purchase Order
Stock Out - can be via Order or Adjustment Out.

I have a scenario whereby I want to highlight columns whereby Stock Out Date is less than Stock in Date. Eg. Date entered for Stock in is 2019 and Stock out is 2018 or 2017, 2016 etc.

Attached is sample file.

New Proposal

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

Sign up

Clarification Board Ask a Question

    There are no clarification messages.