How do I fill rows based on a data changing down a column

**kvne** · 10-05-2023, 10:43 AM

Can someone help me with a macro or code to essentially highlight an entire row based on a data changing throughout a column. I am unable to post images yet but I will best try to describe with an in-message table, but this is for excel.

Number	Name	Item
201358
201358
201358
279090001
279090001
279090001
279090002
279090002
279090002

Based on this examlple, I am asking if something could be run for it to highlight all the "201358" rows grey, be able to see the 279090001 being different and make those rowswhite. Then alternating back to grey for 279090002, so on and so forth.

**TMS** · 10-05-2023, 11:00 AM

One way.

Use column D as a Helper column. In cell D2, put the formula

Formula:

=IF(A2=A1,N(D1),IF(D1=1,2,1))

and copy it down.

Now us the Helper column for your Conditional Formatting. 1 = grey, 2 = white.

**TMS** · 10-05-2023, 06:24 PM

Is this resolved? Or do you need more help?

If you need more help ... Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

How do I fill rows based on a data changing down a column

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How do I fill rows based on a data changing down a column

Re: How do I fill rows based on a data changing down a column

Re: How do I fill rows based on a data changing down a column

Thread Information

Users Browsing this Thread

Similar Threads

Split 1-Column into 2 equal sized columns of data, based on changing quantity of rows

[SOLVED] Fill specific rows with value based on a list of rows in a different column

[SOLVED] column has gaps; need to fill rows with data, based on another column

[SOLVED] need to fill in rows based on column a information

[SOLVED] Is it possible to shade (fill) rows of data alternatively based on date column?

Changing cell fill colour based on date in cell - Multiple rows

[SOLVED] Auto Fill Column with Date based on rows in other column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions