Trying to Perfomr Data valaidtion if # exceeds value in other cell.

[msvoboda27]

	A	B	C	D	E	F
1	This Wk Hrs Worked	Prev Wk Hs worked	Prev all Hrs Worked	Estimate hrs	cumulative hrs	New Total Hs
2	2	4	5	10	9 (sum b:c)	11
3
4

<tbody>
</tbody>

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.

 

[theBardd]

Use a custom DV type with a formula of

=UM($A2:$C2)<=$d2

 

[msvoboda27]

Thank you so much for quick response and solved my issue.
Best, Michael