You did it correctly. For some reason (unbeknownst to me, others might
know the exact conditions under which this happens), Excel sometimes
places the entire formula in quotes, thus making it a string - never
TRUE.

Having selected all cells issue Conditional Formatting and just remove
the quotes. This time it should work.

HTH
Kostis Vezerides

On Jun 27, 4:55 pm, DFrank wrote:
Appreciate the response, but this didnt work. This may sound dumb, but i dont
exactly understand what you mean when you say 'then copy.'

I just selected all cells and put in your formula and this is what happened:http://img246.imageshack.us/img246/6...estion2yc4.jpg

"Jarek Kujawa" wrote:
try to define the following conditional formatting in A1:

Formula Is-=or(MOD(ROW()-2;2*1)+2<=2,A1=CHAR(89))

then copy