Page 1 of 2 12 LastLast
Results 1 to 12 of 17

Thread: Please Help Me,

  1. #1
    azhar aali's Avatar
    azhar aali is offline Senior Member+
    Last Online
    12th November 2015 @ 04:53 PM
    Join Date
    15 Mar 2009
    Location
    KSA
    Age
    37
    Posts
    2,708
    Threads
    287
    Credits
    960
    Thanked
    165

    Default Please Help Me,

    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

  2. #2
    qaiserjanu is offline Member
    Last Online
    25th June 2010 @ 10:06 AM
    Join Date
    28 Dec 2009
    Location
    Karachi
    Age
    28
    Posts
    270
    Threads
    14
    Thanked
    20

    Default

    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

  3. #3
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    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
    Last edited by syar; 13th March 2010 at 09:41 PM. Reason: miss typing

  4. #4
    azhar aali's Avatar
    azhar aali is offline Senior Member+
    Last Online
    12th November 2015 @ 04:53 PM
    Join Date
    15 Mar 2009
    Location
    KSA
    Age
    37
    Posts
    2,708
    Threads
    287
    Credits
    960
    Thanked
    165

    Default

    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

  5. #5
    azhar aali's Avatar
    azhar aali is offline Senior Member+
    Last Online
    12th November 2015 @ 04:53 PM
    Join Date
    15 Mar 2009
    Location
    KSA
    Age
    37
    Posts
    2,708
    Threads
    287
    Credits
    960
    Thanked
    165

    Default

    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


  6. #6
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    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

  7. #7
    azhar aali's Avatar
    azhar aali is offline Senior Member+
    Last Online
    12th November 2015 @ 04:53 PM
    Join Date
    15 Mar 2009
    Location
    KSA
    Age
    37
    Posts
    2,708
    Threads
    287
    Credits
    960
    Thanked
    165

    Default

    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

  8. #8
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    is k leye aap ko header and footer set karne parte hain.
    Detail k leye is section m "insert picture in header and footer deekhain" leekan aap picture ki jagha par dae aur time insert kar dain aap ka masla hal ho jae ga.

    regards

  9. #9
    azhar aali's Avatar
    azhar aali is offline Senior Member+
    Last Online
    12th November 2015 @ 04:53 PM
    Join Date
    15 Mar 2009
    Location
    KSA
    Age
    37
    Posts
    2,708
    Threads
    287
    Credits
    960
    Thanked
    165

    Default

    nai nai wo alg chez ha i mean k sheet sy lagta ha formula lagta ha meanz i think clock hoti ha usk lia

  10. #10
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    try in any cell

    Code:
    =now()

  11. #11
    azhar aali's Avatar
    azhar aali is offline Senior Member+
    Last Online
    12th November 2015 @ 04:53 PM
    Join Date
    15 Mar 2009
    Location
    KSA
    Age
    37
    Posts
    2,708
    Threads
    287
    Credits
    960
    Thanked
    165

    Default

    boooooooooooooooooooooat shukria yahe tha bilkul

  12. #12
    azhar aali's Avatar
    azhar aali is offline Senior Member+
    Last Online
    12th November 2015 @ 04:53 PM
    Join Date
    15 Mar 2009
    Location
    KSA
    Age
    37
    Posts
    2,708
    Threads
    287
    Credits
    960
    Thanked
    165

    Default

    Quote syar said: View Post


    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 .................

Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •