Macro to highlight cells that are 5 business days from trade date

[Jason via OfficeKB.com]

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

 

[SmilingPolitely]

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?

 

[Bob Phillips]

If by tabs you mean sheets, then you will need to give the trade dates a
workbook name and test that. The formula would be something like

=A2>trade_date+5

where A2 is the actual date and trade_date is the name.

 

[Jason via OfficeKB.com]

How do I account for weekends and so forth. Is there a function to
calculate business days?

 

[Bob Phillips]

=A2>WORKDAY(trade_date,5)