+ Reply to Thread
Results 1 to 1 of 1

Conditional Formatting when Certain text is found in Column "a"

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    638

    Conditional Formatting when Certain text is found in Column "a"

    have some information that gets populated on one sheet in Range (A10:E52) Columns (A-E) are merged together:

    What I want is if the text in That row 10-52 in column A = contains Certain text then it would Format the row a certain Way.

    text to match is: (These are Descriptions that get brought through so I would like if they exist to change the format to have a better look.

    Operating/Standby Charges
    Inspections
    3rd Party Tools/Subs
    Miscellaneous Charges
    Core Charges

    example for row formatting: if that text is found then format : (format and shade the Row Grey - From column (A:O) and Bold text and Remove the Center Borders also change row height to 18.

    Every time this runs it would have to reset the Range (a10:o54) back to Normal ( Times New roman, No Bold, font #10, no Fill color & row Height to 24) that way when the category name comes thru in a different location the ending result is correct.

    I have the desired output on Job Ticket tab of my attachment

    Once I have something to try I will need to make additions and check out the results then Make a reply as to how it is working
    Attached Files Attached Files

+ 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] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  2. Replies: 3
    Last Post: 04-14-2013, 11:53 PM
  3. Macro to copy and paste rows based on "text" found in Column A
    By balston2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-09-2013, 12:35 PM
  4. Replies: 2
    Last Post: 08-17-2012, 05:10 AM
  5. Auto Color whole column when found text "Sunday"
    By Kenji in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2009, 09:43 PM

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