Jason via OfficeKB.com wrote:
Hi,
Ive got a spreadsheet with trades placed with clients and I need a macro
that will hightlight the rows that are greater than 5 business days from
the trade date. Our service level agreement states that trades must be
confirmed within 5 business dates but i need the macro to highlight those
trades out of the SLA period. Trade date is in column B but I would like
the macro to go through the following tabs, but to skip tabs with no data:-
PCD, CWA, APL, DIY, EPIC, and VAN. Anyone with ideas would be appreciated.
Thank You

Why not use conditional formatting?