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

Macro to highlight cells that are 5 business days from tradedate
 

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?

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

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

=A2trade_date+5

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

--
HTH

Bob Phillips

"Jason via OfficeKB.com" wrote in message
...
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

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

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

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

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

=A2WORKDAY(trade_date,5)

--
HTH

Bob Phillips

"Jason via OfficeKB.com" wrote in message
...
How do I account for weekends and so forth. Is there a function to
calculate business days?

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