+ Reply to Thread
Results 1 to 2 of 2

need cond format to change row colour on change of unique id - this? =MOD($A1,2)=0

  1. #1
    Registered User
    Join Date
    11-13-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    22

    need cond format to change row colour on change of unique id - this? =MOD($A1,2)=0

    How can I use conditional formatting to give me this:
    (at each change of unique ID in col A-change the entire row colour)

    id (colA) value (colB)
    1 abc
    1 abc
    1 abc
    2 efg
    3 hij
    3 hij

    I found this on the net but isn't working reliably =MOD($A1,2)=0

    Dave
    Last edited by TopDogDave; 11-01-2012 at 10:55 PM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: need cond format to change row colour on change of unique id - this? =MOD($A1,2)=0

    1. Select the first row and extend your selection below upto the last row of the Column-A data
    2. Choose Home|Styles|Conditional Formatting
    3. Click New Rule
    4. Choose the option Use a formula to determine which cells to format
    5. In the formula box, enter
    =COUNTIF($A:$A,$A1)<>1
    6. Click the Format button.
    7. Select a Font color or Fill color to ORANGE.
    8. Click OK, Ok, Apply, Ok.

    Hope this helps!


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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