Swadhin Ray
asked on
Conditional formatting in excel
Hello Experts,
I have need the below conditional formatting for the below rules:
Attached is my sample xls file.
sample.xlsx
I have need the below conditional formatting for the below rules:
green Due by = End date and status = Completed
yellow Due by < End date + 3 and status = Completed/In Progress
red Due by > sysdate and status = Not Started
red Due by > End date + 4 and status = Not Started/In progress
Attached is my sample xls file.
sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER