code change after delete some column

[kerm007]

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 highlight in red after 4
what i'm doing wrong ?

for info i delete column T, U

TY

 

[SanjayGMusafir]

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 highlight in red after 4
what i'm doing wrong ?

for info i delete column T, U

TY

@kerm007 Two suggestions -

First share a link to the post where you got this CF rule. People won't understand the purpose behind. I remember working it hard way to give you this rule.

Second Select the entire sheet and check if rules have changed. When you delete few columns or rows, Excel readjusts rules as per it's understanding... At time we have to recheck rules to function them properly.

 

[kerm007]

hello
here os the tread i was working with you

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

and here the
range it was apply to

=$C$5:$D$5,$C$66:$Z$70,$D$65,$G$4,$C$7:$Z$8,$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$48:$Z$49,$G$47,$C$58:$Z$59,$G$57,$G$63:$Z$64,$C$72:$Z$79,$G$71,$C$17:$Z$17,$C$16:$D$16,$H$16:$O$16,$C$38:$Z$46,$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$103,$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$20,$C$18:$G$18,$K$18:$Z$18,$C$22:$G$22,$K$21:$Z$22,$C$25:$Z$26,$C$24:$G$24,$K$24:$L$24,$K$30,$K$47,$K$57,$K$71,$L$5:$Z$5,$C$27:$H$27,$L$27:$Z$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:$Z$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:$Z$33,$C$37:$L$37,$P$37,$Q$11:$Z$11,$M$80:$M$82,$Q$80:$Z$82,$R$9:$Z$9,$R$34:$Z$34,$R$60:$Z$60,$S$4:$Z$4,$S$6:$Z$6,$S$16:$Z$16,$S$28:$Z$28,$S$30:$Z$30,$S$47:$Z$47,$C$51:$Z$56,$C$50:$O$50,$S$50:$Z$50,$S$57:$Z$57,$S$71:$Z$71,$S$85:$Z$85,$T$24:$Z$24,$T$37:$Z$37


maybe thats why is stop working after i delete some column
Thanks

 

[SanjayGMusafir]

Correct the range and reapply the original formula for CF, it shall work

 

[kerm007]

what do i have to delete not sure
Thanks

 

[SanjayGMusafir]

what do i have to delete not sure
Thanks

Unable to understand what you want to ask/say...

 

[kerm007]

How to correct the range ? after i remove the column ?
Thanks

 

[SanjayGMusafir]

How to correct the range ? after i remove the column ?
Thanks

Remove the previous CF and apply to the whole range/sheet just as you applied for the first time...

 

[kerm007]

ok i will tries that
Thanks '