Conditional Formatting

Hi,

I have a table with different projects and every project has several rows. I would like to color the first four columns of each project, so that each project has an own distinct color. Every project has a unique number. My thinking was to apply a conditional formatting formula but I am not sure which one.

In conditional formatting, each unique set of formats you want to use requires a distinct rule. That is, if you have 10 projects with 10 colors you will need 10 rules. Outside of that you haven't provided enough information to give you a concrete solution. Please consider attaching a sample file so we can see what your data looks like.

There is no single formula that will solve this. It's one CF rule per colour. VBA might work, but you'd still need to program for each eventuality.

Originally Posted by Papabenedetto

I am looking for a single formula that could solve the issue

It's not possible. You can use one rule to get alternating colors, but you must have one rule for each different color.

CF formula:

Formula:

Please Login or Register  to view this content.

	A
1	Project
2	1
3	1
4	1
5	1
6	2
7	2
8	3
9	3
10	3
11	4
12	5
13	5
14	5
Alt colors

I am attaching a sample file that shows what my data looks like.

It's clear what you want to do, but note that you have not attached a file, you have attached a picture of your screen.

As Ali noted, this could be done with VBA but you may find that more complicated than using multiple CF rules.

Next time, please come up with a descriptive, NON-GENERIC thread title.

Glad to have helped.

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

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) 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 each of those who offered help.