need some data validation or formula

in sheet AB AHAD MIR
I HAVE A CHECK BOK IN 'D' IF I SELECT "BILL.NO" I SHOULD BE ABLE TO ENTER IN THE DAT 'F' ONLY(i.e under bill amount)
and it should restrict me to enter in 'G' (i.e the received amount)
and similarly if i select from the check box in 'D' the "payment.no" option it should restrict me to
enter the data in in F (i.e bill amount).
HOPE U UNDERSTOOD
I WILL BE THANK FULL IF U WILL HELP ME OUT

Hi @AliGW,

Very sorry, but unlike my knowledge, my English language is very poor
I hope you will also understand

Thank you very much Brian
for ur response i am humbled ,but dear its not still working
what i want in the work sheet is
In D when there is "recp.no" F should be restricted ,similarly when D carries "bill.no"
G should be restricted and the validation should be for entire sheet
and also
cant we use a drop down in D with two option , bill.no and Recp.no.

kindly guide
thanks and regard
stay safe
BERGI....

@Bergi,

With my workbook, if you select "Recep.no" in D7, you can enter an amount in F7 (BILL AMOUNT) but not in G7 (RECEIVED AMOUNT)
and inversely if you choose "Bill.no"

It's not what you wanted ?

NB : Perhaps the formulas in French are not translated correctly

thank you brain i am highly obliged for ur concern its worth more than appreciation
u have completely understood the trap i am held with
but dear it should be reversed like
if i select "recep.no" i should write in (RECEIVED AMOUNT) and block the (bill amount) column
and when i select the "bill.no" it should allow me to write in (BILL AMOUNT) and block (received amount) column
and it should apply for the whole sheet.....
thanks