data validation-when i clicked on circle invalidation entries

[b166er]

hi members,

i used data validation on my data consists of more than 6000 rows when i clicked on circle invalidation entries there was message(your worksheet contains more than 255 invalid cells.only the first 255 cell will be marked) how can i increase that limit of 255 cells.

[JLatham]

I doubt that you can change this. I searched around and cannot find a
reference to the limit. But 255 is a typical 8-bit counter limit and I
suspect that they are keeping count with an 8-bit counter.

"b166er" wrote:

>
> hi members,
>
> i used data validation on my data consists of more
> than 6000 rows when i clicked on circle invalidation entries there was
> message(your worksheet contains more than 255 invalid cells.only the
> first 255 cell will be marked) how can i increase that limit of 255
> cells.
>
>
> --
> b166er
> ------------------------------------------------------------------------
> b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912
> View this thread: http://www.excelforum.com/showthread...hreadid=552659
>
>