+ Reply to Thread
Results 1 to 2 of 2

format rows based on value

  1. #1
    Registered User
    Join Date
    washington dc
    MS-Off Ver
    Excel 2003

    format rows based on value

    As per the attached, I have 1000's of "ID Detail" value groups. This is just a snippet of the sheet, but I need to color like rows the same so that I can easily reference to the left and the right. I thought this would be simple but can't find a solution anywhere. I know that a table formats every other cell a certain color, but I am looking for something different. My description isn't very strong but check out the attachment as it visually explains it all.

    Any help would be much appreciated.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    MS-Off Ver
    2016 / 2019

    Re: format rows based on value

    This can only be done using VBA or with a trick by adding a column based on your ID but numbers only.

    I do not know the range of your IDs but based on your sample sheet I assume
    - you have only IDs starting with one character ("A", "B", ...)
    - the numbers are from 0 to 99

    based on this assumptions you now can generate a new column with
    Please Login or Register  to view this content.
    ==> A has an offset of 100, B offset of 200, ...

    BUT you can only format this new column with conditional formatting (color scale) and not the complete table

+ 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. VBA/Macro Add new rows with format based on year grouping
    By COfire in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-16-2019, 11:00 AM
  2. Replies: 1
    Last Post: 05-23-2016, 01:53 PM
  3. [SOLVED] Format rows based on entery in one cell
    By masben in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-25-2013, 04:44 AM
  4. Format rows based on predecessor value in a column
    By hoss88 in forum Excel General
    Replies: 6
    Last Post: 03-20-2013, 05:47 AM
  5. Excel 2007 : Conditional format of rows based on cell
    By pancakeonions in forum Excel General
    Replies: 5
    Last Post: 08-20-2010, 05:42 PM
  6. Add subtotal to rows based on the format of cells.
    By josnah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2008, 02:47 PM
  7. format group of rows based on condition
    By Aaron in forum Excel General
    Replies: 0
    Last Post: 01-09-2006, 08:35 PM

Tags for this Thread


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