Conditional formatting if two value equal true

**grantsmith** · 03-16-2013, 06:09 AM

Hi,

I have a table which contains rows of work related info.

I would like the associated row to be highlighted if the date is more then 90 days old and the row isn't marked as complete or cancelled.

Any ideas?

Thanks

**martindwilson** · 03-16-2013, 06:25 AM

loads of ideas! perhaps an explanation as to where the date is and where the row is marked complete/cancelled

**grantsmith** · 03-16-2013, 06:36 AM

Sorry, very new to this.

The date is in B2 and the Job Status is in U2. Dont know if this is relevant, but Job Status is Data Validation List containing the following;

AT PRINT
CANCELLED
COMPLETE
IN PROGRESS
PROOFED
QUOTED

I would also need the this to be active throughout all rows.

Thanks