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

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

--
Message posted via http://www.officekb.com

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?

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.

--
HTH

Bob Phillips

"Jason via OfficeKB.com" <forum@nospam.OfficeKB.com> wrote in message
news:93a63fd77cc24f6d8a7f8dbcd803d68d@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
>
> --
> Message posted via http://www.officekb.com

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

--
Message posted via http://www.officekb.com

=A2>WORKDAY(trade_date,5)

--
HTH

Bob Phillips

"Jason via OfficeKB.com" <forum@OfficeKB.com> wrote in message
news:9210bc391c4647568050199cd1ffffdd@OfficeKB.com...
> How do I account for weekends and so forth. Is there a function to
> calculate business days?
>
> --
> Message posted via http://www.officekb.com