In excel 2007, how do you highlight the entire row when the condition is based on a single cell. please give step by step. Honkus