conditional formating Chip Pearson Chip Pearson's Conditional Format page http://www.cpearson.com/excel/cformatting.htm Conditional Formatting - Referencing another sheet C.F., Using cells on other sheets http://www.cpearson.com/excel/cformatting.htm http://www.cpearson.com/excel/cformatting.htm C.F. Conditional Formatting Chip Pearson Conditional Formatting