+ Reply to Thread
Results 1 to 11 of 11

How to apply conditional formatting to each column separately?

  1. #1
    Registered User
    Join Date
    05-07-2022
    Location
    Italy
    MS-Off Ver
    Excel for Mac 16.60
    Posts
    5

    How to apply conditional formatting to each column separately?

    Dear Excellers,
    I have a list of numbers (hundreds) on each columns and I need to see duplicate values with conditional formatting.
    The problem is that I don't know how to apply that function separately. Each column has to be independent from the others.
    Thank you!

    John

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,847

    Re: How to apply conditional formatting to each column separately?

    Hi John and welcome to the forum,

    Select a single column by clicking on the Letter above the column. Then apply CF using the selected column. Click on the next column head and do it again.
    If that isn't the answer, we need a sample of what you have to understand the problem better. See the yellow banner above to see how to attach a file.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    05-07-2022
    Location
    Italy
    MS-Off Ver
    Excel for Mac 16.60
    Posts
    5

    Re: How to apply conditional formatting to each column separately?

    Dear MarvinP,

    thank you for your fast reply. I know that. The problem is that I have thousands of this columns and I need to do that in human time (all the columns simultaneously).

    Thanks!

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,819

    Re: How to apply conditional formatting to each column separately?

    Try

    Please Login or Register  to view this content.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  5. #5
    Registered User
    Join Date
    05-07-2022
    Location
    Italy
    MS-Off Ver
    Excel for Mac 16.60
    Posts
    5

    Re: How to apply conditional formatting to each column separately?

    I'm using macOS Catalina. Have I to copy that code and past it on Terminal? Or I must paste it somewhere on Excel? Thank you JohnTopley.

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,819

    Re: How to apply conditional formatting to each column separately?

    I don't know anything about MAC-based products so I cannot advise on what is required.

    Please update your profile to show the Excel version you are using.

  7. #7
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B 2016
    Posts
    1,423

    Re: How to apply conditional formatting to each column separately?

    Delete Delete
    Last edited by josephteh; 05-08-2022 at 09:00 AM.

  8. #8
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,576

    Re: How to apply conditional formatting to each column separately?

    Select all columns and use the following CF:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Adapt ranges as required but make sure the absolute and relative references are correct !
    You will of course have the same formatting everywhere
    ( depending on your regional settings you have to replace the comma with a semi colon)
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    05-07-2022
    Location
    Italy
    MS-Off Ver
    Excel for Mac 16.60
    Posts
    5

    Re: How to apply conditional formatting to each column separately?

    Dear Pepe Le Mokko,
    I tried in different ways to use your very clear advice but I failed. I tried to insert as function, use the file you attached and copy my data but doesn't work.
    I think it's strange that a so simple option is so difficult to obtain on excel. Thank You! Anyway finally I found this solution on techcommunity.microsoft.com (I can't link it):

    "‎Mar 19 2020 12:04 PM

    How to conditionally format many columns independently
    Hi,
    I am struggling to find a solution for a problem I encountered. I have a data sheet with many columns and each column represents data from an individual person. In each column, there are words which a person used as a response for a particular instruction."



    I didn't understand the formula, I used the file attached and it worked. Right now understanding the formula is not a priority for me.

    The formula (in italian version) is:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Thank you!
    Last edited by John Stengel; 05-09-2022 at 05:11 PM.

  10. #10
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,576

    Re: How to apply conditional formatting to each column separately?

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  11. #11
    Registered User
    Join Date
    05-07-2022
    Location
    Italy
    MS-Off Ver
    Excel for Mac 16.60
    Posts
    5

    Re: How to apply conditional formatting to each column separately?

    Alright. Thank you!

+ 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. Apply Conditional Formatting if a column Name is matching
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-14-2021, 01:44 PM
  2. How to apply conditional formatting on specific column using java poi
    By purni_04 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-31-2020, 09:58 AM
  3. Replies: 33
    Last Post: 01-19-2018, 03:53 PM
  4. Conditional Formatting apply to 1 Column
    By lexusap in forum Excel General
    Replies: 7
    Last Post: 06-11-2017, 01:53 AM
  5. [SOLVED] Using VBA to apply Conditional Formatting based on a calculation to Column
    By tonygg9 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-12-2014, 09:48 PM
  6. Conditional formatting if in range of values: apply to column
    By marcopietro in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-19-2014, 02:34 PM
  7. How to apply conditional formatting to a whole column
    By scottghansen79 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-05-2010, 05:21 AM

Tags for this Thread

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