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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Formatting not working?
- Thread starter PlumGr8
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,175
- Office Version
- 365
- Platform
- Windows
When comparing numbers with decimals, it is always good to use the ROUND function, lest you may run across this known issue: Floating-point arithmetic may give inaccurate result in Excel - Office
Upvote
0
I'll check that link when I am on a computer that will allow me to access it. Issue is that I do have to keep these values accurately. I actually just had to change everything over because we were using the code to enter straight military time but the rounding errors were leading up to errors in times which effects a lot of other stuff that I had to correct.
Upvote
0
