filter/sort my sheet based on two values

[ROHAN999]

sir

i want to filter/sort my sheet based on two values n column and o column and there after may be i can use column p and q
to filter /sort my data in my sheet

for which i was thinking of using conditional formating but havnt get current formula and mothed to do that as if one will be colored yellow and one will be colored pink then how to find the common which satisfy both conditions-SO THAT I CAN SORT BY COLOR

i want that DOB BETWEEN COLUMN N AND O AND DOJ BETWEEN COLUMN P AND Q NEED TO BE COLRED YELLOW AND PINK REPECTIVELY OR CAN BE SORTED ANY HOW...

PLZ HELP...

SORT SHEET BETWEEN DOB BETWEEN COULMN N AND O AND THEN SORT SHEET BETWEEN DOJ BETWEEN COLUMN P AND Q

SAMPLE SHEET IS ATTACHED