Small issue with a CF formula !

[serge]

Hi,
I'm using Excel 2007 on my computer windows 2007 my file works fine, no problem, I transfer this exact same excel file onto another computer with windows 11 and this formula =OR($X5:$AA5<=$W5:$Z5) doesn't work until I go into the Conditional Formatting tab then Manage Rules / Edit rules and click Ok and it works !!! why it isn't working in the first place ?
Thank you.

 

[jkpieterse]

Does it also work after pressing Control+Shift+Alt+F9 ?

 

[serge]

No it doesn't

 

[serge]

Any body have an idea why it happen ? what could be the problem ?
I tried again today on my old computer Windows 2007 it works fine but it give me this little problem when I use it on my new computer windows 11, I don't think that the windows has nothing to do with it but I mention it. What could be the problem in excel ?
Thank you.

 

[jkpieterse]

Can you share a file which shows the issue?

 

[serge]

This is the way it looks below.

and this the way it need to look below.

the formula that I use are :
=IF(ROWS($H$5:$H5)>COUNTA($B$5:$B$11)*COUNTA($C$5:$C$11)*COUNTA($D$5:$D$11)*COUNTA($E$5:$E$11)*COUNTA($F$5:$F$11),"",CONCATENATE(TEXT(INDEX($B$5:$B$11,MOD(INT((ROWS($H$5:$H5)-1)/(COUNTA($C$5:$C$11)*COUNTA($D$5:$D$11)*COUNTA($E$5:$E$11)*COUNTA($F$5:$F$11))),COUNTA($B$5:$B$11))+1),"00"),TEXT(INDEX($C$5:$C$11,MOD(INT((ROWS($H$5:$H5)-1)/(COUNTA($D$5:$D$11)*COUNTA($E$5:$E$11)*COUNTA($F$5:$F$11))),COUNTA($C$5:$C$11))+1),"00"),TEXT(INDEX($D$5:$D$11,MOD(INT((ROWS($H$5:$H5)-1)/(COUNTA($E$5:$E$11)*COUNTA($F$5:$F$11))),COUNTA($D$5:$D$11))+1),"00"),TEXT(INDEX($E$5:$E$11,MOD(INT((ROWS($H$5:$H5)-1)/(COUNTA($F$5:$F$11))),COUNTA($E$5:$E$11))+1),"00"),TEXT(INDEX($F$5:$F$11,MOD(ROWS($H$5:$H5)-1,COUNTA($F$5:$F$11))+1),"00")))

Then :
=MID(H5,1,1)+0
=MID(H5,2,1)+0
Etc...
The CF :
=OR($X5:$AA5<=$W5:$Z5)
=$AA5>$AB$1
=AND($W5=$W$2,$X5=$X$2,$Y5=$Y$2,$Z5=$Z$2,$AA5=$AA$2)
Sorry I can not copy the file directly.
Thank you for the help I hope someone can maybe find why it doesn't work on my new computer ? I'm using Excel 2007.

 

[serge]

I fix the problem, It was in the Excel Options some of the rules were not tick the same as my older excel file, when I came out of it, all came out working good.
Thank you for your time and sorry for the inconvenient.

 

[jkpieterse]

It would be nice if you would share the fix with us rather than leave us in the dark

 

[serge]

Hi jkpieterse,

Actually I didn't fix the problem it work for couple times but still there, there is another issue that doesn't work on my new computer when I press F4 to look a cell it doesn't work !! so I I'm not sure what is it and I don't want to bother you guys with something that could be a faulty software or my computer.
I appreciate the help.