Conditional Formatting - IF Function

Hi there
I've attached a snippet of a spreadsheet I use at work. It normally has 300+ patients listed and I need to do two things

1. Find a way to highlight any rows that do not have any data in columns F thru to S (we've not booked another appointment for these patients) and then copy those rows ( A thru to S) into either another worksheet or workbook (so we can check the patient file for the next appointment or discharge the patient).

2. Find a way to highlight any rows where the data in columns F thru to S has passed and then copy those rows (A thru to S) into either another worksheet or workbook.

Any ideas would be much appreciated.

Cheers
thecat131