conditional formatting question

[kerm007]

hello
i have conditional formatting in place that highlight cell in red when there a sequance of 4 x in a row it stop after colum z
here my range:
=$C$5:$D$5,$C$66:$Z$70,$D$65,$G$4,$C$7:$Z$7,$G$6,$C$10:$Z$10,$G$9:$J$9,$C$15:$Z$15,$G$14:$Z$14,$C$23:$Z$23,$G$21,$C$31:$Z$32,$G$30,$C$49:$Z$49,$G$47,$C$58:$Z$59,$G$57,$G$63:$Z$64,$C$72:$Z$77,$G$71,$C$17:$Z$17,$C$16:$D$16,$H$16:$O$16,$C$38:$Z$39,$C$36:$D$36,$H$36,$C$61:$Z$62,$C$60:$D$60,$H$60:$I$60,$H$5,$C$12:$Z$13,$C$11:$E$11,$I$11,$C$83:$Z$84,$C$81:$E$82,$C$86:$Z$86,$C$85:$E$85,$I$85:$O$85,$C$89:$Z$93,$C$87:$E$87,$I$87,$C$4,$C$6,$C$9,$C$14,$C$21,$C$30,$C$47,$C$57,$C$63:$C$64,$C$71,$J$65:$Z$65,$C$29:$Z$29,$C$28:$F$28,$J$28:$O$28,$C$88:$F$88,$J$88:$K$88,$K$4,$K$6,$C$19:$Z$19,$C$18:$G$18,$K$18:$T$18,$C$22:$G$22,$K$22:$Z$22,$C$25:$Z$26,$C$24:$G$24,$K$24:$L$24,$K$30,$K$47,$K$57,$K$71,$L$5:$T$5,$C$27:$H$27,$L$27:$R$27,$C$35:$Z$35,$C$33:$H$33,$L$33,$L$36:$Z$36,$M$11,$M$60:$N$60,$C$80:$I$80,$I$81:$I$82,$M$87:$T$87,$N$9,$C$34:$J$34,$N$34,$O$4,$O$6,$O$30,$O$47,$O$57,$O$71,$O$88:$Z$88,$P$24,$P$33:$S$33,$C$37:$L$37,$P$37,$Q$11,$M$80:$M$82,$R$9:$W$9,$R$34:$Z$34,$R$60,$S$4,$S$6:$W$6,$S$16:$T$16,$S$28:$T$28,$S$30,$S$47:$X$47,$C$52:$Z$56,$C$50:$O$50,$S$50:$V$50,$S$57:$Z$57,$S$71,$S$85,$T$24,$T$37:$Z$37,$C$8:$Q$8,$U$8:$Z$8,$U$11,$K$21:$Q$21,$U$21,$Q$80:$Q$82,$U$80:$Z$80,$V$27:$Z$27,$V$60:$Z$60,$C$79:$Z$79,$C$78:$R$78,$V$78:$Z$78,$W$4,$W$30:$Z$30,$W$33,$W$71,$W$85:$Z$85,$X$5,$X$16:$Z$16,$X$18,$C$20:$T$20,$X$20,$X$24,$X$28,$C$51:$T$51,$X$51:$Z$51,$X$87:$Z$87,$Y$11:$Z$11,$Y$21:$Z$21,$U$81:$U$82,$Y$81:$Z$82,$C$48:$V$48,$Z$48,$Z$50,$C$42:$Z$46,$C$40:$X$41,$C$95:$Z$98,$C$94:$X$94,$C$100:$Z$103,$C$99:$X$99

how to make it work after that or to infinit colum ?

also i have one conditional formatting that do on the same range when there x in one cell in green same range
Thanks

 

[SanjayGMusafir]

Here are the links to your previous posts where you asked similar question and were answered.

Hope it helps

code change after delete some column

Hello all i have a conditional formatting in place =OR(AND(C4="x",B4="x",A4="X",XFD4="x"),AND(C4="x",D4="x",E4="x",F4="x"),AND(C4="x",B4="x",D4="x",E4="x"),AND(C4="x",B4="x",A4="X",D4="x")) for some reason i have to delete 2 weeks schedule and now if i put an x to the sequence it does not...

www.mrexcel.com

conditional formating

Hello how can i do conditional formatting when the same character appear 4 time in a row in let say row B3 to b24 i tries different thing but what i found is only for a column Thanks

www.mrexcel.com

 

[kerm007]

Thanks