msvoboda27
New Member
- Joined
- Feb 9, 2018
- Messages
- 30
- Office Version
- 365
- 2021
- Platform
- Windows
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]This Wk Hrs Worked
[/TD]
[TD]Prev Wk Hs worked
[/TD]
[TD]Prev all Hrs Worked
[/TD]
[TD]Estimate hrs
[/TD]
[TD]cumulative hrs
[/TD]
[TD]New Total Hs
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]4
[/TD]
[TD]5
[/TD]
[TD]10
[/TD]
[TD]9
(sum b:c)
[/TD]
[TD]11
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Trying to understand how I can perform data validation if exceed value in other cell. Input Cell A2 prevent data from being entered if exceed value in D2 (estimated hrs)
The max hours can post would be 10, the example show worked total11 and need to cap at 10.
Can someone please offer guidance.
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]This Wk Hrs Worked
[/TD]
[TD]Prev Wk Hs worked
[/TD]
[TD]Prev all Hrs Worked
[/TD]
[TD]Estimate hrs
[/TD]
[TD]cumulative hrs
[/TD]
[TD]New Total Hs
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]4
[/TD]
[TD]5
[/TD]
[TD]10
[/TD]
[TD]9
(sum b:c)
[/TD]
[TD]11
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Trying to understand how I can perform data validation if exceed value in other cell. Input Cell A2 prevent data from being entered if exceed value in D2 (estimated hrs)
The max hours can post would be 10, the example show worked total11 and need to cap at 10.
Can someone please offer guidance.