+ Reply to Thread
Results 1 to 3 of 3

Highlight first cells of every value changes in data of column B and Ignore Black cells

  1. 07-06-2023, 11:50 AM #1
    abhinavbinkar
    abhinavbinkar is offline
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Nagpur, India
    MS-Off Ver
    Excel 2010 / 2013
    Posts
    293

    Highlight first cells of every value changes in data of column B and Ignore Black cells

    I needed to highlight first cells of every value changes in data of column B and also it should ignore black cells in column B.

    Example sheet is attached.
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-06-2023, 12:24 PM #2
    vinitdhuri
    vinitdhuri is offline
    Registered User
    Join Date
    12-01-2011
    Location
    India
    MS-Off Ver
    Microsoft 365
    Posts
    33

    Lightbulb Re: Highlight first cells of every value changes in data of column B and Ignore Black cell

    You can use conditional formatting for the same. Attached file for your reference.
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 07-06-2023, 12:41 PM #3
    abhinavbinkar
    abhinavbinkar is offline
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Nagpur, India
    MS-Off Ver
    Excel 2010 / 2013
    Posts
    293

    Re: Highlight first cells of every value changes in data of column B and Ignore Black cell

    Thanks you very much. SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Compiling non black cells of one column to another but..
    By Betta-J in forum Excel General
    Replies: 13
    Last Post: 01-16-2019, 11:53 AM
  2. Highlight Dups but ignore Blank cells
    By HawkI in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2015, 06:33 PM
  3. Formating Input Cells Blue, Formulated Cells Black, Linked Cells Green
    By Jason Carlos in forum Excel General
    Replies: 0
    Last Post: 01-21-2015, 12:05 PM
  4. How to ignore black cells
    By ACrossley1 in forum Excel General
    Replies: 2
    Last Post: 10-29-2014, 05:49 AM
  5. Conditional formatting. Highlight cells that meet a criteria but ignore blank cells.
    By CEM in forum Excel General
    Replies: 5
    Last Post: 05-18-2013, 07:49 PM
  6. Black out certain cells if the column contains X
    By ineedthisspread in forum Excel General
    Replies: 6
    Last Post: 12-21-2012, 05:47 AM
  7. Condtional Formatting: highlight MIN(s) but ignore blank cells
    By needsomehelpher in forum Excel General
    Replies: 5
    Last Post: 09-24-2010, 04:42 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1