Results 1 to 7 of 7

Apply Conditional Format If Any Cells On Same Row Contain Top 10% Values

Threaded View

  1. #1
    Registered User
    Join Date
    10-20-2019
    Location
    USA
    MS-Off Ver
    365 / 2016 for Desktop or Mobile Devices
    Posts
    9

    Apply Conditional Format If Any Cells On Same Row Contain Top 10% Values

    As a tech neophyte, I am quite flustered by inability to apply conditional formatting to first cell on each row if any other cell(s) on that same row contain a top 10% value. For instance,

    NOW: All cells with top 10% values conditionally formatted by green fill and bold-faced gold text

    Excel Sample Table 1 IMAGE.png

    DESIRED RESULT: "HOUR" Column cells on same row as any others that contain top 10% values auto format

    Excel Sample Table 2 IMAGE.png

    OR Entire ROW with any top 10% cell value auto formats as below:

    Excel Sample Table 3 IMAGE.png
    Thanks in advance for all helpful tips. And I do apologize for the huge pics but can't figure out how to post tables per your published Forum Rules.
    Last edited by CluckeyJD; 11-03-2019 at 11:02 PM. Reason: adjust text alignment
    Your Guest For Best IT Quest

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to apply conditional format
    By esbencito in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-09-2018, 11:28 PM
  2. [SOLVED] How To Apply Conditional Format To Cell
    By Kingswood in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-09-2015, 12:59 PM
  3. apply conditional format to every 4th row
    By jlanderson18 in forum Excel General
    Replies: 2
    Last Post: 07-18-2013, 01:39 PM
  4. Only apply conditional format if cell val > 0
    By moorzee in forum Excel General
    Replies: 2
    Last Post: 05-10-2013, 05:02 PM
  5. Apply Conditional format only when cells are active?
    By bob63el in forum Excel General
    Replies: 3
    Last Post: 04-03-2013, 10:18 PM
  6. Replies: 3
    Last Post: 09-13-2012, 03:25 AM
  7. Conditional Format-apply to every row
    By hassankhan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2009, 03:24 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