Conditional Formatting - IF Function

[thecat131]

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

[protonLeah]

The Conditional formula

Please Login or Register  to view this content.

highlights any row with an expired date
the formula

Please Login or Register  to view this content.

highlights rows with no dates entered
This macro will copy not move the specified data to separate sheets:

Please Login or Register  to view this content.

[thecat131]

Hey Ben
You are an absolute marvel - thank you soo much for your help.

Cheers
thecat131