+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting for multiple colunns

  1. #1
    Registered User
    Join Date
    02-05-2020
    Location
    Hyderabad
    MS-Off Ver
    2019
    Posts
    1

    Conditional Formatting for multiple colunns

    I have a small doubt
    Say i have Column formatted "top 10" & now i wanted to apply it for some 5k Columns how i'm suppose to do it.

    I tried to use format painter but it is taking as the range when i'm selecting multiple columns.

    I'm attaching the file here, please do help me out.
    Attached Files Attached Files

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,261

    Re: Conditional Formatting for multiple colunns

    Use this condition
    Please Login or Register  to view this content.
    -9^9 could be replaced to 0 in the case of only positive values are present
    Attached Files Attached Files
    Last edited by BMV; 02-05-2020 at 03:56 AM.

+ 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. Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  2. [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
  3. Replies: 1
    Last Post: 07-21-2013, 06:57 AM
  4. [SOLVED] Compare colunns and if do not match write row to a new sheet
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2013, 05:48 PM
  5. [SOLVED] Conditional Formatting based on multiple strings in multiple cells
    By lily_ruiz_06 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-27-2013, 04:23 PM
  6. Replies: 5
    Last Post: 12-28-2012, 02:06 PM
  7. Replies: 2
    Last Post: 08-26-2010, 07:46 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