Excel 2010 Conditional Formatting assistance
Posted on 2011-10-19
I have an Excel Sheet. It contains 2000 Rows, 4 columns, which contain a Contact ID (Number), a contact type (Number 1 or 2) and a Display Name (Text) and a Completed (text).
I want to highlight entire rows depending on whether the Contact Type is a 1 or a 0.
I found articles explaining how to do it, but I can't seem to get it to highlight the entire rows, just the cells which meet the criteria.
The column letters are A, B, C, D
Rows Start at 3, and go to 2003
Ideally if the 4th column contained anything, it would make that row another colour so we can see easily it's completed.