Problems with conditional formatting

[jonislindwert]

Hi,

I have a problem with the conditional formatting. When I want to sort the sheet on column A som of the arrows for some of the columns disappears. However when I look under "manage rules" I can see that the formula is still there.

Before sorting

After sorting

 

[Andrew Poulsom]

What conditional formatting have you applied to column AA?

 

[jonislindwert]

What conditional formatting have you applied to column AA?

I have used "percentile" 5 arrows colored. Intervalls 90 , 65, 35, 10

 

[Andrew Poulsom]

I can't reproduce that behaviour. Do you want to put your workbook on a share like Box.com so that I can take a look at it?

 

[jonislindwert]

https://www.box.com/s/q8bnga9wilz2elvrip7b

 

[Andrew Poulsom]

OK so what are you sorting and by what?