+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting a table with a color when it detects a change

  1. #1
    Registered User
    Join Date
    05-29-2019
    Location
    Houston, USA
    MS-Off Ver
    Excel 365
    Posts
    3

    Conditional formatting a table with a color when it detects a change

    Hello,

    Is it possible to format a table either of these ways? One would involve conditional formatting where it highlights a certain color when it detects a change in a cell. The preferable option would be the screenshot where there are spaces between to separate each new supplier/seller to make the sheet easier to read. Are either of these possible to do?

    example 1.PNG
    example 2.PNG

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Conditional formatting a table with a color when it detects a change

    How is data entered into this table. Is it copied and pasted, is it entered manually. Either way it's going to involve taking a before and after snapshot. It's a matter of whether you take a snapshot of the whole table or one cell at a time.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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] How to Change Icon Color in Conditional Formatting!
    By Rajeshkumar R in forum Excel General
    Replies: 6
    Last Post: 05-25-2021, 12:51 AM
  2. [SOLVED] Conditional formatting color change if any in row is true
    By CLSSY56 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-08-2018, 11:59 AM
  3. [SOLVED] Text Color Change Using Conditional Formatting
    By iamstikman in forum Excel General
    Replies: 15
    Last Post: 11-18-2014, 05:39 PM
  4. Conditional Formatting - Change row color (MACRO)
    By Mike112 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-16-2012, 10:05 AM
  5. Conditional formatting - color change
    By Kearse56 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2007, 05:39 PM
  6. Replies: 2
    Last Post: 08-26-2005, 01:05 PM
  7. Replies: 3
    Last Post: 07-28-2005, 12:05 PM

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