Need Excel Help...

.Kencs · 17 Jul 2013 at 08:32

Morning All,

Basically, I have a spreadsheet with several columns, 2 of the columns are 'Date / Time Raised' and 'Priority Level'

For example:

Date / Time Raised: 17/07/2013 08:00:00
Priority: 3

Now, if Priority 3 is 72 hour fix, can the row highlight red when it reaches that time period (20/07/2013 08:00:00) then if it is still on the spreadsheet by this time, the row will highlight red alerting me it is over the priority time scale?

Hope that make sense...

Poolybit · 17 Jul 2013 at 08:42

How many other priorities are there other than P3?

.Kencs · 17 Jul 2013 at 08:49

Poolybit said:
How many other priorities are there other than P3?

P1, P2, P3 and P4

kevpuk · 17 Jul 2013 at 09:08

If your dates are in Column A, for example, you can use this formula to get the amount of hours that have passed between now and the date:

=(DAY(NOW()-A1)*24)+HOUR(NOW()-A1)

...then, with conditional formatting, you could build up some rules using the formula; something along the lines of:

Condition1 = Formula is =(DAY(NOW()-A1)*24)+HOUR(NOW()-A1)>72 ......(72 is amount of hours)

Thing is, certainly with earlier versions of Excel, you can only put 3 conditions in place; this means you can get a 4th only be making it the default/normal position.

Hope that is a start point

.Kencs · 17 Jul 2013 at 09:51

kevpuk said:
If your dates are in Column A, for example, you can use this formula to get the amount of hours that have passed between now and the date:

=(DAY(NOW()-A1)*24)+HOUR(NOW()-A1)

...then, with conditional formatting, you could build up some rules using the formula; something along the lines of:

Condition1 = Formula is =(DAY(NOW()-A1)*24)+HOUR(NOW()-A1)>72 ......(72 is amount of hours)

Thing is, certainly with earlier versions of Excel, you can only put 3 conditions in place; this means you can get a 4th only be making it the default/normal position.

Hope that is a start point

Perfect mate thank you