Please Help Me,

[azhar aali]

SALAM bahio,
main 1 baat jana chahta hon k excel ki sheet main asa koi function ha k jab koi date expire ho rhai ho to wo column color change kar ly ta k hume pata chal gye masln as a remindr kam kary, maslan 1 sheet asi ha k us main medican
ki date expiry lakhi ha wo date jab aye to wo column red wagra ho gye
boat shukria

[qaiserjanu]

bhai jan jahan rak mara khyal hai to ayasa koi option ya formula nahi hai.Waisay agar mujhay kahin say pata chal jata hai.ap ko day donga.ok

[syar]

Use conditional Formatting under Format menu.

Select your range/column jis m expiry date ho.

Phir conditional formatting m ja kar cell vlaue is Equal to =TODAY()
likhain aur format k option m colur apni marze k muntakhib kar lain.

Agar phele he se kuch entries aise hion jin ki date expire ho chuke hon tu "Value is greater than or equal to select karain
aur phir =today() likh kar enter kar dain.



regards

[azhar aali]

bhai boat shukria aap nay batya laken mujhe khas samaj ni i aghar easy ho aap k lia to image k sath post karin to easy ho gya ga samjnay main
boat shukria

[azhar aali]

bhai shukria samj aa gye ha muje boat shukria ,
main excel learn kar raha hon na to jaldi samaj nai i. bhai muje or b useful formulas sakha dain aap ki boat mehrbani ho ge

[syar]

salam::

Glad k aap ka masla hal ho geya.

bhai muje or b useful formulas sakha dain

aap ko is course k lessons m bohat kuch seekhne k moqa mele ga. Agar aap ne dehan se reading ki tu. Dosra agar kisi khas formula k poochna he tu u r welcome?

regards

[azhar aali]

boat shukria bhai
acha 1 formula hota ha k print k daty waqt us page pay date or time aata ha wo aghar bata dain aap

[AAB88]

salam::

Glad k aap ka masla hal ho geya.



aap ko is course k lessons m bohat kuch seekhne k moqa mele ga. Agar aap ne dehan se reading ki tu. Dosra agar kisi khas formula k poochna he tu u r welcome?

regards

Bhai kia ap conditional formatting k kch examples d skty hain plz.



Best regards,

[azhar aali]

Use conditional Formatting under Format menu.

Select your range/column jis m expiry date ho.

Phir conditional formatting m ja kar cell vlaue is Equal to =TODAY()
likhain aur format k option m colur apni marze k muntakhib kar lain.

Agar phele he se kuch entries aise hion jin ki date expire ho chuke hon tu "Value is greater than or equal to select karain
aur phir =today() likh kar enter kar dain.



regards

bhai masla ho gya ha maine excel 2007 kia ha is main kis thara yah formula apply karun .................

[syar]

try in any cell

=now()

[azhar aali]

boooooooooooooooooooooat shukria yahe tha bilkul

[syar]

salam::

Home tab m conditional formatting----> new rules--->format only cell that contain--->phir cell value -->equal to-->=today()

regards