+ Reply to Thread
Results 1 to 11 of 11

Convert Format Condition to vba code

  1. #1
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    Convert Format Condition to vba code

    I have the following format condition :
    formula: =OR(CELL("col")=COLUMN(),(CELL("row")=ROW()))
    font color : Orange
    back color : Black
    Usage: Highlighting the selected cell
    Request:
    I need to convert format condition in the attached file to vba code.
    Please help
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Convert Format Condition to vba code

    Please Login or Register  to view this content.
    Last edited by Parth007; 03-23-2016 at 06:04 AM.
    Regards
    Parth

    I appreciate your feedback. Hit * if u Like.
    Rules - http://www.excelforum.com/forum-rule...rum-rules.html

  3. #3
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    Re: Convert Format Condition to vba code

    I don`t want to enter that formula.This formula is placed in conditional format rule in order to highlight the selected cell.
    Please open the attachment in order to understand the matter.

  4. #4
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Convert Format Condition to vba code

    See this

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    Re: Convert Format Condition to vba code

    No..no..no
    Forget all above.My request is:
    In the attachment,there is a conditional format.I want to convert it to a vba code
    Is this clear enough????

  6. #6
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Convert Format Condition to vba code

    the above code is the conditional formatting via VBA code....

  7. #7
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    Re: Convert Format Condition to vba code

    Great job Mr ."Parth007".But I want the same color like in the attachment.
    Please help

  8. #8
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Convert Format Condition to vba code

    Hello Prince
    Give this a try
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  9. #9
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Convert Format Condition to vba code

    Here you Go...!!!!

    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    Re: Convert Format Condition to vba code

    I managed to change the color myself.
    Mr. YasserKhalil thank you for your code but it`s very slow.
    Great job Mr ."Parth007".your answer is the best.

  11. #11
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Convert Format Condition to vba code

    My pleasure Leprince... happy to help you

    thanks Yasser for add in's

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need formula or code to convert number(s) from custom format to number format
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-12-2015, 07:44 PM
  2. Need code to convert numbers in to data format
    By winmaxservices1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-05-2015, 02:47 AM
  3. Need code to convert numbers in to data format
    By winmaxservices1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2015, 09:58 AM
  4. Macro to convert zip code +4 format to text format
    By narendrabr in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-17-2014, 09:42 AM
  5. VBA Code or Formula to Convert format of extracted Data
    By Bpd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2014, 01:17 PM
  6. Need code to convert date as format of dd-mmm-yyy at once click
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2013, 04:52 AM
  7. Need Formula/VBA Code to convert date in String Format to Normal Date format
    By Karthik Sen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2012, 04:54 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1