I have a spreadsheet and im hoping to add a macro or something so that if a column is the 'wrong' number, it will change the color of the entire row. i used an if statement to Say OK or NO, and i would like it to change colors if NO appears.