Excel 2007 : IF/AND TRUE/FALSE and two criteria

Name the Ranges in Data1 sheet A1 to A20, Name, B1:B20, Decade, C1:C20, Condition..

Then go to Data2 sheet, select range from A2 to B38

go to Home tab, Conditional Formatting and Select New Rule

Select Use formula to determine which cell to format...

enter formula:

=MATCH($A2&FLOOR(YEAR($B2),10)&"TRUE",Name&LEFT(Decade,4)+0&Condition

click Format and choose colour pattern