hyperdreamz
12-03-2006, 06:31 PM
.
Hi All
I need assistance to write a macro to conditionally format the attached sheet
The sheet deals with Issues and Ticket Age for a given issue
In column “B” contains the numerical value of the TOTAL number of hours this ticket has been open
In column “C” contains the numerical value of the TOTAL number of hours since this ticket was last updated
On “Sheet 2” is a MASTER Index of Maximum response time for a particular issue (Changes daily)
I want to use multiple conditional formats, based on MASTER Index on “Sheet 2”
E.g.
The Maximum allowed age of a ticket for a "Os Issue" is 24Hrs (=Sheet2!B2)
If the "Ticket Age" for an "Os Issue” exceeds 24 I want row’s A:C to show in a Red font
If the ("Ticket Age" - "Modified Age") for an "Os Issue" exceeds 24 I want row's A:C to show in a White font with a Red background
I want the formatting to update its self if changes are made in the “MASTER Index”
I don’t need the formatting to update in real-time, if it is updated every time the macro is run that’s fine
Is this possible ? :banghead:
-HyperDreamz
.
Hi All
I need assistance to write a macro to conditionally format the attached sheet
The sheet deals with Issues and Ticket Age for a given issue
In column “B” contains the numerical value of the TOTAL number of hours this ticket has been open
In column “C” contains the numerical value of the TOTAL number of hours since this ticket was last updated
On “Sheet 2” is a MASTER Index of Maximum response time for a particular issue (Changes daily)
I want to use multiple conditional formats, based on MASTER Index on “Sheet 2”
E.g.
The Maximum allowed age of a ticket for a "Os Issue" is 24Hrs (=Sheet2!B2)
If the "Ticket Age" for an "Os Issue” exceeds 24 I want row’s A:C to show in a Red font
If the ("Ticket Age" - "Modified Age") for an "Os Issue" exceeds 24 I want row's A:C to show in a White font with a Red background
I want the formatting to update its self if changes are made in the “MASTER Index”
I don’t need the formatting to update in real-time, if it is updated every time the macro is run that’s fine
Is this possible ? :banghead:
-HyperDreamz
.