+ Reply to Thread
Results 1 to 3 of 3

Automate formatting for multiple cells with different criteria

  1. #1
    Registered User
    Join Date
    09-19-2022
    Location
    new york, new york
    MS-Off Ver
    office 365
    Posts
    2

    Automate formatting for multiple cells with different criteria

    Hello all,

    I come to you as a basic excel user. I have been compiling data for a hobby that requires me to format it a certain way. I would like to know if some of the steps I do manually can be done automatically or quicker. I will try to explain this clearly as possible. I have data that gets pulled 3 times a week. I want to highlight the data (Cells b6 through BR6) that is equal to data (cell BT6 through BX6) in a particular row. Is it possible to write a rule of some sort to do this automatically? I will provide a screenshot to help you understand what I'm trying to do. I also want to automatically pull copy data from rows b8 through br8 and paste that data in BT8 through BX. I did everything manually in the outline so you could see what I wanted. I appreciate anything you can offer. let me know if there is anything else I can answer or provide for your assistance.

    make thanks in advance.

    the new guy
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by bmore07; 09-19-2022 at 03:07 PM.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,877

    Re: Automate formatting for multiple cells with different criteria

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    09-19-2022
    Location
    new york, new york
    MS-Off Ver
    office 365
    Posts
    2

    Re: Automate formatting for multiple cells with different criteria

    Thanks for the quick reply Alan. I copyied and paste the data from a website manually. There is no code used. I also updated the file up so you should find the whole file there. Thank you for the information to obtain the information I'm looking for. If you need anything else, please let me know.

+ 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] Automate Ranking on Multiple Criteria
    By rynny in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-27-2021, 11:22 AM
  2. how to automate conditional formatting and reverse conditonal formatting
    By anita2017 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2019, 12:36 PM
  3. [SOLVED] Conditional Formatting over multiple cells with multiple criteria validator
    By effendrew in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-31-2015, 05:05 PM
  4. Vba to automate multiple web queries from a list on worksheet cells
    By harryy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2013, 07:57 AM
  5. Automate concatenation between single cell and multiple target cells
    By garnerseo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-16-2013, 07:15 AM
  6. Replies: 5
    Last Post: 12-28-2012, 02:06 PM
  7. Conditional formatting with multiple criteria in different cells
    By Dinghy60 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-12-2012, 08:43 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