Results 1 to 5 of 5

Thread: Excel main contitional formating

  1. #1
    Ajmal Hussain is offline Junior Member
    Last Online
    5th May 2022 @ 10:01 PM
    Join Date
    27 Sep 2008
    Location
    Yanbu-Saudi Arabia
    Gender
    Male
    Posts
    9
    Threads
    2
    Credits
    1,220
    Thanked
    0

    Default Excel main contitional formating

    Dear bro,
    main yeh pochna chahta hon k main excel main eik work sheet main jis jis cell main sum ka formula hai us call main color karna chata hon with contitional formating

  2. #2
    *Sahir* is offline Advance Member
    Last Online
    18th March 2024 @ 06:06 AM
    Join Date
    24 Dec 2009
    Location
    IT.Dunya.Com
    Age
    34
    Gender
    Male
    Posts
    4,565
    Threads
    264
    Credits
    1,404
    Thanked
    398

    Default

    Dear kia app ke kehny ka ye matlab hai ke AP Formula Show karna chahty hain... With Color...? Please apny Sawal ko Explain karin... Shukria....

  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



    Agar aap conditional formatting k zarya formula wale cells ko highlight karna chahte hain tu is k leye aap ko macro coding ki zaroorat ho ge (mere ilam k mutabiq) agar kisi aur dost ko koi tareeqa pata ho tu m bhee intrested hon.

    Leekan agar aap ye chahte hain ka sheet me jo bhe formula ha unko color kar don tu is k leye tareeqa ye ha.

    1. Press F5.
    2. GOTO k menu m se special select Karain
    3. New open hone wale window m "FORMULA" select karain
    4. OK press karain aap notice karain ga k sheet m jahan bhee formula ha wohe cell select howe hain. Apne marze ki formatting select kar lain sirf unhe cells par apply ho ge jahan formula laga ha


    hope this will help you.

    regards

  4. #4
    sohail1966's Avatar
    sohail1966 is offline Advance Member
    Last Online
    24th February 2024 @ 03:53 PM
    Join Date
    29 Sep 2011
    Gender
    Male
    Posts
    752
    Threads
    19
    Credits
    357
    Thanked
    40

    Default

    nice sharing..

  5. #5
    iqbalatish's Avatar
    iqbalatish is offline Senior Member+
    Last Online
    18th March 2014 @ 03:48 PM
    Join Date
    31 Dec 2010
    Age
    42
    Gender
    Male
    Posts
    398
    Threads
    50
    Credits
    980
    Thanked
    10

    Default

    conditional formatting mean agar paln valu yo hu tu paln color auto use ho,es ko kis tarha apply kya jata hy ,ws ka jawab share kari

Similar Threads

  1. excel main
    By faizan374 in forum Ask an Expert
    Replies: 1
    Last Post: 16th September 2014, 09:41 PM
  2. excel main
    By faizan374 in forum Ask an Expert
    Replies: 11
    Last Post: 24th December 2013, 06:24 PM
  3. FAT32 ko NTFS main kesy convert kro without formating.
    By Arslan Star in forum Ask an Expert
    Replies: 3
    Last Post: 20th July 2013, 07:01 PM
  4. Solved Excel main figures(hindsoun) ko words main Badalna....
    By danireh in forum Solved Problems (IT)
    Replies: 4
    Last Post: 17th January 2012, 04:17 PM
  5. Help Me in Date Formating In Excel
    By imranshakeel in forum Ask an Expert
    Replies: 3
    Last Post: 29th August 2009, 09:07 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
  •