hi guys,
i have created a worksheet so i can track my workload for the service department where i work.

i have the following columns
SR/IR NUMBER
SERIAL NUMBER
CUSTOMER
TRACKING NUMBER
DELIVERED
DATE BOOKED IN
DAYS TO REC
DECON COMPLETED
ORACLE UPDATED
RTC
TRACKING NUMBER

what i want excel to do is the following - when i enter something into column A (sr/ir number) i want the whole row to turn red
then when i enter the date it arrives in colomn E (delivered) i want the row to turn orange and then when i enter a "Y" in to column I (oracle updated) it will then turn green

i have done this before but the spreedsheet has been deleted and i have no idea what to look for.

thank you in advance for your help :-)
lee