Hi All,
I've a worksheet with 3 columns namely Task, Status & Start Date.
Task column contains various tasks.
Status column has a Data Validation list containing 3 different statuses 'Open', 'In-Progress' and 'Completed'
Start Date column contains a date.
My requirement is to color the cells in Status columns based on the selected status. I've used conditional formatting to do it as below.
If 'Completed' status is selected, the cell is colored 'Green'
If 'In-Progress' status is selected, the cell is colored 'Yellow'
However I'm unable to get the below requirement.
My requirement for 'Open' status is as follows:
If the date in Start Date column of the corresponding row having 'Open' status is greater than today, then the color would be 'No Color'.
If the date in Start Date column of the corresponding row having 'Open' status is lessthan today, then the color would be 'Orange'.
Any help in this regard is appreciated. Thank you.
Bookmarks