Saturday, November 15, 2014

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?


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]hilikkus80[MEDIA DJ #242]vivi7685165
[MEDIA DJ #243]vivi76[MEDIA DJ #244]NA85vivi76
---
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
------------------------------------------------------------------------------------------------------------------------------------------------------