This is a simple conditional format, applies to cells K7:K41
File Link:
https://1drv.ms/x/s!ApYmeret_YzZnQeQXzk8PPQ4J2Yk
This is for a timesheet....
Condition Format Rule:
Formula: =$k7<>sum($L7:$O7)
Basically, if the total hours scheduled do not match the total hours assigned, then the cell goes RED.
Cells K7:K41 is formula referencing cells U7:U41 [=u7]
Cells U7:U41 is a formula =S7-T7:
Cells S7:S41 calculates the total hours charged based on a military time format 10:00PM (start) - 14:00PM (end) = 3.00
Cells T7:T41 calculates the lunch breaks (in hours) so U7:U41 is the total hours minus the lunch break hours.
The conditional format IS (yes IS) behaving properly on all cells K7:K41 with this exception:
If the start time is 6:30AM and ends at 7:00AM, so the value of cell K7 is 0.50 and the sum of L77 is 0.50, but the still cell goes active,
The misbehavior is ONLY for the times between 6:30AM-7:00AM
If the start time is any other time, the format behaves properly.... it only misbehaves on that specific condition.
Its got to be something simple and stupid... i just cant see what....
Thanks
BV
File Link:
https://1drv.ms/x/s!ApYmeret_YzZnQeQXzk8PPQ4J2Yk
This is for a timesheet....
Condition Format Rule:
Formula: =$k7<>sum($L7:$O7)
Basically, if the total hours scheduled do not match the total hours assigned, then the cell goes RED.
Cells K7:K41 is formula referencing cells U7:U41 [=u7]
Cells U7:U41 is a formula =S7-T7:
Cells S7:S41 calculates the total hours charged based on a military time format 10:00PM (start) - 14:00PM (end) = 3.00
Cells T7:T41 calculates the lunch breaks (in hours) so U7:U41 is the total hours minus the lunch break hours.
The conditional format IS (yes IS) behaving properly on all cells K7:K41 with this exception:
If the start time is 6:30AM and ends at 7:00AM, so the value of cell K7 is 0.50 and the sum of L77 is 0.50, but the still cell goes active,
The misbehavior is ONLY for the times between 6:30AM-7:00AM
If the start time is any other time, the format behaves properly.... it only misbehaves on that specific condition.
Its got to be something simple and stupid... i just cant see what....
Thanks
BV