Conditional formatting that displays one of two colours, depending on cell content

Hi.

Is there any way to create Excel 2010 conditional cell formatting such that if the cell content is one specific value (i.e. 0), the cell is filled with one colour, but if it contains another value (i.e. >=50), the cell is filled with a different colour? I would then need to copy that formatting down a whole column of cells.

If that is possible, then I would ideally like to extend the fornmatting even further, by stating that if the cell value =0, but there is specific text in another separate column, then the cell shouldn't fill with the specified colour. If, however, the cell value is 0 and that specific text isn't present in that other column, then the cell must fill with the colour.

I am thus really looking for three different conditional formatting rules applying to the same cell: a) cell content =0 and specific text in another column, b) cell content =0 without specific text in another column, and c) cell value >=50.

Can this be done?

Thanks.

Thanks guys! I further complicated my own scenario a bit by wanting additional "exclusion conditions", as I got some unexpected cell fills due to other existing text entries in column B that I hadn't originally catered for, and thus also had to exlude from their effect on the conditional formatting of A1. Thankfully the AND formula allows one to keep adding comma-separated conditions as necessary. It thus worked a treat, although I assume that I needed to convert the absolute cell references to relative ones before applying the conditional formatting to all the cells of the column range.

Appreciate the fast and accurate assistance!