see

http://www.excel-it.com/excel_condit...formatting.htm