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.

 

[ebea]

Could a simple recalculation of the actual sheet, solve it (Shift+F9). Give it a go

 

[serge]

Thank you guys.

 

[serge]

I tried (Shift+F9) don't work either Thank you ebea.

 

[felixstraube]

For your problem with that it doesn't update all the time. Do you have your calculation set to Automatic (menu "Formulas/Calculation/Calculation Option")?

 

[felixstraube]

If you have for example 1, 2, 2, 3, 4. Would that need to be highlighted in red?
Because if it doesn't then the formula should be:

=OR(X5:AA5<W5:Z5)

Without the "=" sign.

 

[serge]

Hi felixstraube,
Yes the calculation are set to Automatic.
Your formula is not working for my table it highlight most of the numbers.

 

[serge]

Like RoryA said it must be a bug, so don't worry guys Thank you very much to all for your time, I would just have to deal the way it is.

 

[felixstraube]

sorry my mistake
It should be:

=OR($X5:$AA5<$W5:$Z5)

Fixing the columns

 

[serge]

Thank you for your formula it works but does the same thing than mine, this is funny because this is the ONLY CF formula that does that I never had this problem with any other before, I would like to know why ? Why it works after I open the CF tab then it works ???

Thank you for your help and everyone else, don't worry guys it's not a big deal just annoying.

 

[felixstraube]

If you can share the file i could have a look.
Upload it to a cloud storage and share the link here.