I am sure this is a pretty basic task, but I am a novice with Excel. I am making a simple inventory spreadsheet for work, keeping track of hard drives. I have drive serial number on the left for rows, then things such as date in/date out, po#, etc. for the columns. What I want to do is have the row be highlighted in a certain color (most likely red) when all the cells have not been populated. When all cells have been filled with the necessary information, the color will vanish, leaving just the "no fill" color (white). I would like this to load automatically when the spreadsheet is opened, and refresh when a new drive is entered on it as well. Thanks for the help!!