Problem with CF not working correctly !

[serge]

Hi,

I have a table with combinations sets generated in numerical order with a formula that highlight in red when the number are not in numerical order.
But it doesn't work all the time, many time what I do is that I open the CF tab, click on the red formula click my cursor in that formula without changing anything then click Ok and it work !
But it's really annoying to do that each time.
Why the CF don't work automatically ?
I may have to change something to make it works every time, can someone tell me what is wrong with it, Please ?

Thank you.

 

[myall_blues]

Change the OR to AND, and change the equality.

=AND($X5:$AA5>=$W5:$Z5)

 

[serge]

Thank you myall_blues, Your formula is good but do the opposite of mine.

My formula does it's purpose, the problem with it is that it doesn't work automatically, so is there something to tic in the CF window or putting the formula first I'm not sure why it doesn't work automatically ???

 

[serge]

Quick video to show the problem.

123.mp4 | Powered by Box

app.box.com

 

[myall_blues]

Thank you myall_blues, Your formula is good but do the opposite of mine.

My formula does it's purpose, the problem with it is that it doesn't work automatically, so is there something to tic in the CF window or putting the formula first I'm not sure why it doesn't work automatically ???

Yes you're correct sorry - I got slightly confused.

What other CF formulas cover the same range? Can you post a picture of all CFs - it was a bit quick in the video. From what I did see I think you need to tick 'Stop if True' for that condition.

 

[serge]

Red =OR($X5:$AA5<=$W5:$Z5)
Green =AND($W5=$W$2,$X5=$X$2,$Y5=$Y$2,$Z5=$Z$2,$AA5=$AA$2)
Grey =$AA$2
Grey =$Z$2
Etc...

 

[myall_blues]

Have you tried ticking stop if true?

 

[serge]

Yes I did then I close and save the file then reopen the file and the red CF is gone not responding that's kind of weird it does that !!! I guess there is no solution for it, Thank you for you time.

 

[myall_blues]

Yeah sorry. Sounds like it could be corrupted.

 

[RoryA]

Could be a bug - 2007 was full of them!