yogi_Condionally Format Cells For Specified Conditions Where A Cell Equals Cell In Row Below

                Google Spreadsheet   Post  #1833

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-15-2014

post by Simon LEFEUVRE:
(conditional formatting depending on another row)

Hello!

I know how to make conditional formatting if a cell is exactlty the same than an other in the same row.

I have make this to perform that.

=AND($D:$D=$K:$K;NOT(ISBLANK($K:$K)))

Now I want to highlight a cell if a cell in the next row has the same text. Is it possible?

Here is my Speedsheet : https://docs.google.com/spreadsheets/d/1W_YqidRlT7eIV8cEtSE3Lw_B82MDa6zm_Ve89ZEsPyw/edit?usp=sharing

I want to highlight (in the first sheet "ListeMDJ") in the column D the cell Dx where K(x+1) has the same value

In the example below I want to highlight the first occurence of "vivi76" because it appears in the next row :

[MEDIA DJ #241]	hilikkus	80	[MEDIA DJ #242]	vivi76	85	165
[MEDIA DJ #243]	vivi76		[MEDIA DJ #244]			NA	85	vivi76

---
I try to highlight cells D and G when the same text appears in 2 consecutives lines.

So in 4 cases :

if D1=D2 : highlight D1 & D2

if D1=G2 : highlight D1 & G2

if G1=G2 : highlight G1 & G2

if G1=D2 : highlight G1 & D2

I think I have found the formulas, but I want to be sure I can simplifly in maximum

------------------------------------------------------------------------------------------------------------------------------------------------------