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.