Change row colour when value changes

L

Legacy 396030

Guest

• Mar 17, 2017

• #2

Format as a table and go to design and choose the preset one you like.

 

Upvote 0

R

RubberChicken

Board Regular

Joined

Jun 20, 2013

Messages

50

• Mar 17, 2017

• #3

Won't that just colour every other row?
I want the colours grouped by the reference in column A

 

Upvote 0

L

Legacy 396030

Guest

• Mar 17, 2017

• #4

Sorry I misunderstood the question. Perhaps a sort of column A so the unique identifiers are in order? Then each group will be in order.

 

Upvote 0

R

RubberChicken

Board Regular

Joined

Jun 20, 2013

Messages

50

• Mar 17, 2017

• #5

Thanks, BillyRay

They are sorted. I just need them coloured

Cheers

 

Upvote 0

L

Legacy 396030

Guest

• Mar 17, 2017

• #6

Since they are now sorted will the every other row color change satisfy your need? If so insert the table design. I have used a macro to auto sort a column so it's dynamic but can't remember now. Maybe you can post a different thread on that?

 

Upvote 0

FormR

MrExcel MVP

Joined

Aug 18, 2011

Messages

7,150

Office Version

1. 365

Platform

1. Windows

• Mar 17, 2017

• #7

Hi, you can do quite easily with a helper column (which can be hidden of course), for example:

Excel Workbook
	A	B
1	Header	Helper
2	A	TRUE
3	A	TRUE
4	A	TRUE
5	B	FALSE
6	C	TRUE
7	C	TRUE
8	D	FALSE
9	D	FALSE
10	E	TRUE
11	F	FALSE
12	F	FALSE
13	F	FALSE
14	F	FALSE
15	G	TRUE
16	H	FALSE
17	H	FALSE
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2	1. / Formel ist =$B2	Abc

 

Upvote 0

L

Legacy 396030

Guest

• Mar 17, 2017

• #8

Excellent suggestion FormR! When using the Excel Jeanie how do you post it so it shows the borders?

 

Upvote 0

FormR

MrExcel MVP

Joined

Aug 18, 2011

Messages

7,150

Office Version

1. 365

Platform

1. Windows

• Mar 17, 2017

• #9

BillyRaySpivy said:

When using the Excel Jeanie how do you post it so it shows the borders?

Click to expand...

Hi, it just does for me - if you edit your post that tends to mess it up, but usually the HTML is still on your clipboard at that time, so just delete and re-paste as part of any edits.

 

Upvote 0

L

Legacy 396030

Guest

• Mar 17, 2017

• #10

I select all and copy the html then paste it. Maybe I am doing this wrong? It shows the range but without borders.

 

Upvote 0