Can someone tell me if this is possible and if so how can I do it?
This is my issue I have two tabs. Tab1 has information exported from an
access database telling me if the date is a completed, forecasted, overdue or
has no date. I am doing a vlookup to pull these dates into tab 2. I need a
way to change the cell shading on tab 2 based on the status listed on Tab 1
i.e. Apple date 1 should be gray (status completed), date 2 should be yellow
(overdue), Orange date 1 white (not due yet) and date2 should also be white
(no date).

Tab 1
Name date1 status date2 status
Apple 1/1/07 Completed 2/2/07 Over due
Orange 12/1/07 Forecasted No date


Tab 2
Name date1 date2
Apple 1/1/07 2/2/07
Orange 12/1/07

Please note tab 2 cant be modified by adding rows or columns.