Unable to apply Conditional Formatting on large number of cells with empty cells in between.

[omairhe]

Hello all,
I would like you to test this problem and possibly come to a conclusion. First I want you to type 40 in cell A1 and apply conditional formatting to it, for instance Data Bar . A2 will remain blank and without Conditional Formatting. Now I want you to copy A1 and A2 simultaneously and paste it till A1000. I do notice that CF works in this fashion if I paste the figures down until row 759 . However, past this row and the formatting will no longer work all though they are applied. I have my data exactly like this where I would not want my CF to be applied on every 2nd row, (eg A2, A4, A6, A8 etc. and it is more than 900 rows.
Is this some kind of an excel glitch? How to resolve this?

Thank you and will appreciate any help.

 

[Butty578]

I just tried this and I don't have a problem with the conditional formatting working? Tested it to 1000 as requested.

Did you enter the conditional formatting for cells to edit yourself or did you use the data bar function?

 

[omairhe]

Did you enter the conditional formatting for cells to edit yourself or did you use the data bar function?

I've used Data Bar function because of ease of use and unique colors they have to offer.
I tried manually doing data bars but doesn't make a difference.

I've now discovered that I can make it to work for even values only, for instance if you paste the same way up until row 999 , it may not work for you as well. because it is an odd row number. but if you paste it till 1000th row , it will work.
Why so I don't know..

 

[omairhe]

But what if I want to paste CF on every 3rd row. up til 1000th row. It will not work because 1000th is an even number and I am pasting an odd number (example : A1:A3
But now when I paste till 999th row the values are pasted and the CF is pasted but they simply don't seem to work anymore.