Conditional formatting on a searchable database

Hi all,

Apologies if this is posted in the wrong location.

I have created a searchable database using a macro, I think. I used an online tutorial which I cannot post the link to.

The idea is that patients get blood tests every so often and I created a database that allows the user to search on the patient's unique identifier to show cumulative results. If you type the patient's ID into the search field and select ID from the filed list it will tabulate and graph results for 2 tests.

However, I would also like to highlight in red any result which has increased or decreased by 15% from the previous result for that patient (i.e. after the filter is applied). Presently I can only get it to format on the result above on the unfiltered table, so most likely results from a different patient.

I have attached an example sheet that contains made-up information but demonstrates the principle.

Any help would be appreciated.

Apologies if this is not clear or I have posted into the wrong forum.


Thanks
Streebek

Hey,

Thanks so much for the response and apologies for the delay in acknowledging it (thought I would get an email notification).

I will give this a try and see how I get on.


Thanks again.

Take care