How to sort two columns by the highlighted field? - Microsoft Community

if has better idea how this, i'm open anything!

 

i trying track deadlines real estate projects, each project has 2 separate deadlines - title , feasibility. title deadline comes first, once we've finished requirements title deadline, i'll need track project feasibility deadline.

 

i've used conditional formatting highlight title deadline if still need finish requirements, , highlight feasibility deadline if we've finished title requirements (see below):

is there way can sort these columns in order of current deadline we're working on? need see both deadlines on report, super helpful if in chronological order (there 9/25 deadline towards bottom of list have been missed). in slow part of season , have triple these numbers in few months, want make sure nothing slips through cracks. ideas??

is there way can sort these columns in order of current deadline we're working on? need see both deadlines on report, super helpful if in chronological order (there 9/25 deadline towards bottom of list have been missed). 

if have field tell deadline working on adding calculated field has proper date can sorted , not show in report (remember sorts reports must done within report query sort ignored report).

Office / Access / Windows other / Office 2016