Format cells in Excel base on multiple conditions
- or -
Post a project like this1750
$112
- Posted:
- Proposals: 1
- Remote
- #2423559
- Awarded
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.
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.
SHIVA G.
100% (2)Projects Completed
3
Freelancers worked with
3
Projects awarded
60%
Last project
18 Jun 2019
Fiji
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