Conditional Formatting - using multiple formulas

Hi,

i have a spreadsheet where I need the data in one cell to make another cell show a specific work=d and colour, its drvingin me crazy.  Please help