Data Validation/Conditional Formatting Assistance Needed

[Freidamae]

Hello,

This site has helped me numerous times before I registered as a user. I have been digging for the right answer to my question and I can't seem to find it this time. So, here goes:

I have a time sheet spreadsheet. Hours worked are recorded in time. Hours charged to each division are calculated in numbers. Hidden, we have calculations that change the hours worked in time to a number.

I need to make it to that the sum of charged hours equals the number of hours worked each day.

In the farthest right cell -1.50, there should be a Data Validation Stop Error Alert as the -1.50 is less than 0. This is one of the many formulas that I have tried.

I can use Conditional Formatting to turn cells red (but that tells my user nothing) and I have a formula where it will return text if the cell is not 0. However, my boss would like a more blatant message. Text can be ignored, Data Validation requires a fix to the problem.

Any suggestions are greatly appreciated.

Thanks!

 

[Freidamae]

Thanks, I will give it a try.

I know I'm not being clear in asking.

I will work on the add in soon.

 

[awoohaw]

Thanks for understanding.

All I need to know are what values are keyed in by the user (the actual cell makes no difference if you can figure cell positions out from posted solutions).
What are the values keyed in? What calculation is compared to what other keyed in value?