Link to home
Start Free TrialLog in
Avatar of Swadhin Ray
Swadhin RayFlag for United States of America

asked on

Conditional formatting in excel

Hello Experts,

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
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Swadhin Ray

ASKER

thanks