Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-3355371%22%20slang%3D%22en-US%22%3EConditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3355371%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Faust25_0-1652249486454.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370669iABF0609845D92A47%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Faust25_0-1652249486454.png%22%20alt%3D%22Faust25_0-1652249486454.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIn%20this%20table%20I%20want%20to%20highlight%20%2F%20change%20the%20colors%20of%20the%20rows%20(from%20Column%20(%22A%2CB%2CC%22)when%20from%20Column%20%22A%22%20changes%20its%20values%20-%20example%20from%20column%20%22A%22%20all%20the%20rows%20that%20has%20%22Apple%22%20in%20them%20will%20highlight%20it%20in%20a%20different%20color%2C%20then%20the%20next%20from%20%22Boy%22%20it%20wont%20have%20any%20color%20changes%20but%20on%20the%20%22Cat%22%20will%20have%20the%20same%20color%20change%20as%20the%20%22Apple%22%20-%20so%20that%20will%20happen%20when%20every%20change%20of%20values%20from%20Column%20%22A%22%20happens%20-%20is%20it%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3355371%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3355663%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3355663%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F586834%22%20target%3D%22_blank%22%3E%40Faust25%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Faust25_0-1652253892124.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370677iD497D48B7E017347%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Faust25_0-1652253892124.png%22%20alt%3D%22Faust25_0-1652253892124.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EManaged%20to%20do%20it%20by%20adding%20number%20based%20on%20unique%20values%20from%20Column%20%22A%22%20and%20putting%20isodd%20function%20on%20conditional%20formatting%20but%20now%20I%20want%20to%20learn%20how%20to%20put%20a%20number%20sequence%20based%20on%20the%20changes%20of%20values%20on%20Column%20%22A%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3355723%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3355723%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F586834%22%20target%3D%22_blank%22%3E%40Faust25%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEnter%201%20in%20A3.%3C%2FP%3E%0A%3CP%3EIn%20A4%2C%20enter%20the%20formula%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DA3%2B(B4%26lt%3B%26gt%3BB3)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20down%20from%20A4.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3355734%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3355734%22%20slang%3D%22en-US%22%3EOh%20my%20goodness!%20thank%20you%20this%20helps%20a%20looooooot%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3356126%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3356126%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F586834%22%20target%3D%22_blank%22%3E%40Faust25%3C%2FA%3E%26nbsp%3BIf%20anyone%20wants%20the%20end%20results%3A%20here%20is%20the%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3356535%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3356535%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F586834%22%20target%3D%22_blank%22%3E%40Faust25%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20office%20365%2C%20UNIQUE%20function%20can%20be%20useful%20instead%20of%20adding%20extra%20columns.%20I%20don't%20like%20to%20use%20extra%20columns%20to%20do%20something.%20i%20always%20prefer%20base%20data%20to%20do%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20works%20as%20you%20said%20but%20no%20need%20to%20put%20an%20extra%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DISODD(COUNTA(UNIQUE(%24B%243%3A%24B3)))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sekoleyte_0-1652263143659.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370715i60E74D4EA43A081B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Sekoleyte_0-1652263143659.png%22%20alt%3D%22Sekoleyte_0-1652263143659.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20share%20the%20file%20with%20you%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Faust25_0-1652249486454.png

In this table I want to highlight / change the colors of the rows (from Column ("A,B,C")when from Column "A" changes its values - example from column "A" all the rows that has "Apple" in them will highlight it in a different color, then the next from "Boy" it wont have any color changes but on the "Cat" will have the same color change as the "Apple" - so that will happen when every change of values from Column "A" happens - is it possible?

5 Replies

@Faust25 

Faust25_0-1652253892124.png

Managed to do it by adding number based on unique values from Column "A" and putting isodd function on conditional formatting but now I want to learn how to put a number sequence based on the changes of values on Column "A"

@Faust25 

Enter 1 in A3.

In A4, enter the formula

 

=A3+(B4<>B3)

 

Fill down from A4.

Oh my goodness! thank you this helps a looooooot

@Faust25 If anyone wants the end results: here is the file

@Faust25 

 

Hi there.

 

If you have office 365, UNIQUE function can be useful instead of adding extra columns. I don't like to use extra columns to do something. i always prefer base data to do it.

 

It works as you said but no need to put an extra column.

 

=ISODD(COUNTA(UNIQUE($B$3:$B3)))

 

Sekoleyte_0-1652263143659.png

 

I share the file with you as well.