To apply a rule, i need to choose from that column to infinite. Like column "zz" "zzz".


Could you tell me which one is the last one?

AFAIK Excel does not cope well with infinity as the highest value it can work is is 9e307

In XL 2007 the last column should be XFD ( thank you Google)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks sir

I don't know which version of Excel you're using, but if it's not 2007 you can always find out by simply using <End>,<Right>. Just go out to the far right of the existing data—<Ctrl-End> should get you there—then hit the <End> key, then hit the right arrow. (Don't hold <End> down like a <Shift> key; hit it and release, then hit <Right> and release.) That'll take you to the end of the worksheet, and you can then see for yourself which column is last in your version.