I have a large worksheet and wish to perform an advanced filter on the data.

Can anybody tell me if you can create a single advanced filter which will
look for data in two columns using the 'or' function. For instance, to
filter out those records with a value of greater than 5 in column C 'or' a
value greater than 5 in column D?

I can create advanced filters but have never asked it to look at multiple
values before.

Thank you.
Louise