+ Reply to Thread
Results 1 to 7 of 7

find then format cell

  1. #1
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2021 Pro Plus
    Posts
    645

    find then format cell

    hi,

    i have a code below what i want to do is in blue color

    Set Range1 = Range("A1:C100").Find("DATA")
    If Not Range1 Is Nothing Then

    center align then bold format

    End If

    how do i also, using the range of A1 to C100
    find cell that has values of more than 11 characters then make it bold format
    and left align
    also insert entire row above the cell that has more than 11 characters
    Last edited by k1dr0ck; 01-30-2017 at 02:16 AM.

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

    Re: find then format cell

    May be
    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

  3. #3
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2021 Pro Plus
    Posts
    645

    Re: find then format cell

    actuallly using it in this code but cant get it to work, excel hangs after i run the code

    Please Login or Register  to view this content.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,749

    Re: find then format cell

    Your explanation is not clear to me.
    Better upload a small sample file with before/after.

    This is only my guess.
    Please Login or Register  to view this content.

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

    Re: find then format cell

    May be
    Please Login or Register  to view this content.

  6. #6
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2021 Pro Plus
    Posts
    645

    Re: find then format cell

    sorry i got confused myself
    what i want to do is

    1. copy DATA sheet to a new sheet
    2. rename new sheet to BBBB
    3. for DATA sheet clearcontents A to C, make bold format false for A to C also, make A horizontal-right align
    4.1 for BBBB sheet within (A1:A200) find "DATA" then horizontal-center align
    4.2 for BBBB sheet within (A1:A200) find cell value which has more than 11 character then left align and insert entire row above

    i can do steps 1 to 3, my problem is step 4

    attached file, before sheet and after sheet
    Attached Files Attached Files
    Last edited by k1dr0ck; 01-30-2017 at 10:56 PM.

  7. #7
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2021 Pro Plus
    Posts
    645

    Re: find then format cell

    got it! although not the best code

    Please Login or Register  to view this content.

+ 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. [SOLVED] How to find out format condition cell color?
    By alee001 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-05-2014, 03:42 AM
  2. Do Until you find a cell with a value in date format
    By dmasters4919 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2013, 08:22 PM
  3. [SOLVED] Select a cell -> find cell value in workbook then format
    By bobbybill in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-09-2012, 10:09 AM
  4. [SOLVED] to find the conditiona format of a cell in vba
    By R..VENKATARAMAN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2006, 10:40 PM
  5. Find the Format of a cell
    By Chris in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2005, 01:05 PM
  6. Find the Format Type of a cell
    By Chris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2005, 09:05 PM
  7. [SOLVED] find word in a cell then change cell format
    By motopoyo@spymac.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2005, 09:06 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