Row to change colour if time is exceeded.

II need the whole row to turn red (IF when the time entered in column (AS & AT) is exceeding the times below.

EG something like : if column G is urgent and is more than 4 hours after AS and AT then turn row red.

OR

If colum G is Medium and is more than 48 hours after (AS & AT) then turn the row red.


PRIORITY TIMES

Urgent - 4 Hours -
High 24 Hours
Medium 48 Hours
Low 3 Days

Please feel free to add the code to the sheet if needed.

i need the following code.

example of what i need..


A1 - 3:30:00PM ( manually entered)

+

B1 - 48 ( as in 48 hours)

=

C1 - EQUALS

D1 - Now Time ( i know code for this)

E1 - Need code that if D1 is less than C1 turn row red



thanks