Should be simple but being stubborn. I have 2 works books, and I know I get the error of not being able to format across workbooks. So in one workbook I have 10 cells that reference another works book, ex. "workbook 1 cell B10 shows 100.6, workbook 2 links to and also shows 100.6 in cell D10". So now within book2 I have another sheet that adds up the hours to compare against the "master" number on book1. I have just a simple - if not equal to this number turn red, formatting, but its not working. When the numbers are all matched it still shows red? Any ideas?