Hi, I am having an issue with applying conditional formatting in Excel 2007. I basically have a spreadsheet that lists student's course information. When they have completed you use a cell drop down to change their status from 'Live' to 'Completed'. I want the entire row to change to yellow when the status is 'Completed'. I used to be able to do this easily in 2003 by highlighting the entire spreadsheet (as it contains hundreds of records) and applying the condition. If I do this in 2007, it just changes the cell with the text 'Completed' in it yellow (rather than the whole row). Can anyone help with this? Thank you, Jumping Frog.