Results 1 to 7 of 7

Thread: Excel Experts Plz Help Me.....................

  1. #1
    Stanha1989's Avatar
    Stanha1989 is offline Senior Member+
    Last Online
    1st February 2013 @ 03:08 PM
    Join Date
    13 Sep 2011
    Gender
    Male
    Posts
    487
    Threads
    54
    Credits
    0
    Thanked
    38

    Default Excel Experts Plz Help Me.....................


    Umeed hai sab dost kharyat se hongay.
    mujhay excel main aik aisa farmula chahiye, for example
    main aaj ki date dalta ho 09/01/2012,
    06 months k bad Automatically expire nazar ata ho...
    OR
    kia asa hosakta hain k date k sath days bhi automatically accuont hotay ho.......for exmp, 09/01/2012 = (01), 10/01/2012 = (02)

    Please Important hain help karay..



  2. #2
    Stanha1989's Avatar
    Stanha1989 is offline Senior Member+
    Last Online
    1st February 2013 @ 03:08 PM
    Join Date
    13 Sep 2011
    Gender
    Male
    Posts
    487
    Threads
    54
    Credits
    0
    Thanked
    38

    Default




  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

    salam

    for your 1st query see the below link shayad ap ka masla hal ho gai.
    http://www.itdunya.com/t295175/

    for 2nd query please provide screen shot of your data k data kis tarah aap enter karte hain.

    regards

  4. #4
    Stanha1989's Avatar
    Stanha1989 is offline Senior Member+
    Last Online
    1st February 2013 @ 03:08 PM
    Join Date
    13 Sep 2011
    Gender
    Male
    Posts
    487
    Threads
    54
    Credits
    0
    Thanked
    38

    Default

    Thank you bro..
    Ap ne jo link diya hain us se Question No 2 solved hogaya.. mager question no1 solved nahi howa........

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

    Waise tu bohat sa method hain. Lekan easy Conditional Fomatting k zarye ha k jese he 60 days sa oper ho aap ka cell ka colour change ho gai.

    Follow the below steps( I assume aap excel 2007/2010 istimal kar rahain hain.
    Apna date k column ko select karain aur phir

    Home Tab----> Manage Rule---> Cell value is---> lessthan---> aur neche deya gaya fomula copy kar dain. AUr apni marze ki formatting ya fill colour set kar lain.
    Code:
    =today()-60
    Please test and feed back
    regards.

  6. #6
    Stanha1989's Avatar
    Stanha1989 is offline Senior Member+
    Last Online
    1st February 2013 @ 03:08 PM
    Join Date
    13 Sep 2011
    Gender
    Male
    Posts
    487
    Threads
    54
    Credits
    0
    Thanked
    38

    Default

    Quote syar said: View Post
    Waise tu bohat sa method hain. Lekan easy Conditional Fomatting k zarye ha k jese he 60 days sa oper ho aap ka cell ka colour change ho gai.

    Follow the below steps( I assume aap excel 2007/2010 istimal kar rahain hain.
    Apna date k column ko select karain aur phir

    Home Tab----> Manage Rule---> Cell value is---> lessthan---> aur neche deya gaya fomula copy kar dain. AUr apni marze ki formatting ya fill colour set kar lain.
    Code:
    =today()-60
    Please test and feed back
    regards.

    Sorry brother!!!!!!
    Samaj main nahi ata .....

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

    Sorry mistake ho gai ha darasal zahan m aik aur thread k jawab tha jo m n yahan post kar dia.
    Aap ya conditional fomat ka tahat kar sakte hain. k jab bhe aap ki de gai mudat pore ho cell highlight ya colour change kar la ga. is k leye aap apni range ya column ko select karain phir

    1. excel k menu m home tab pa click karain.
    2. Conditional formatting par click karain.
    3. Conditional formatting k menu m sa "Highlight cell rules" par click karain.
    4. phir "Less Than" ko select karain
    5. format cell that less than m above deya gaya formula copy kar dain
    6. with k drop down m sa apni marze ki formatting ya custom formatting ko select kar k apni marzi ki font style ya fill color choose kar k ok kar dain.

    jab bhe aap ki date 30 din sa oper ho gi cell automatic highlight ho jae ga.

    regards

Similar Threads

  1. Solved EXCEL Experts Please help
    By engr.fahad in forum Solved Problems (IT)
    Replies: 16
    Last Post: 24th June 2012, 01:15 PM
  2. To ms excel experts
    By usman_mohammad2 in forum Ask an Expert
    Replies: 10
    Last Post: 9th October 2009, 12:17 AM
  3. MicroSoft Excel short cuts
    By khurshid akhtar in forum General Discussion
    Replies: 1
    Last Post: 17th January 2008, 02:58 PM
  4. MS Office 2000 Shortcut Keys
    By general in forum General Discussion
    Replies: 4
    Last Post: 31st May 2007, 04:07 PM
  5. Excel Shortcut Keys
    By cuticle in forum General Discussion
    Replies: 3
    Last Post: 29th January 2007, 07:45 AM

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
  •