Exel Expert Help plz

[faheemgul]

dosto muje exel ka ek formula banba hai wo bana deain ya tareeka bata deain plz
formula kuch es tarah honna chahia
NAme
Location:
Issuing Date:
Date of Interence:
Date of Expire:
Alert Date :
Days:
Garanti Emigaration:
Days me 28 k lie Green colore ho aur 58 k lie Red coloer ho
Grantee me office k lie ho red aur Customer ke lie Blue

[NadeemGul]

aap ki baat samaj nahi aaye, plz apney sawal ko explain karain.

[faheemgul]

muje exel ka formula banana hai jis ki tafseel me ne bata de hai plz help

[faheemgul]

S.No. Name Nationality Issuance Date Entrance Expires Alert Days Gaurantee Emigration More One month Finish Person

[Rashid Jan]

es mein konse formulas chaiye aap ko aap ek screen shot bi send karo take pata to chale aap chahte kiya ho aap ki baat samjh mein nahe aati ke formula konsa chaiye aap ka aur aap ne jo last post ki he wo to bilkul easy he ye to aap formulas ke bina bi bana sakte ho dear

thankx

[faheemgul]

mere pass work book hai jis me maen es tarah ka formula banana chahta hoon
jis tarah k es pic me show hai

S.No. Name Nationality Issuance Date Entrance Expires Alert Days Gaurantee Emigration More One month Finish Person
Alert ke lie jab date khatam ho jai to phir red cell writing red ho jai
aur ye formula sab cells per kaam kare