Alternate Row Shading - conditional formula not working

Hi,

I have been trying make my Excel 2007 shade every odd row in a specific column. I have tried about a dozen different websites, among them the following:

http://spreadsheetpage.com/index.php...al_formatting/
http://office.microsoft.com/en-au/ex...010251644.aspx

I have done everything exactly as shown there – it didn't work. Excell either informs me that the formula is invalid or it applies it... but nothing changes. What I would like to do is to select a column and use a conditional formula to shade every other row in that column.

I have tried this one:
=MOD(ROW(),2)=0

it was invalid until I changed it to get the following:
="MOD(ROW(),2)=0"

I have tried slightly different versions, too. I have tried to use MS support in Polish (my Excel is in that language), however it's automatically translated, including the coding. English one was of no practical use nor have i been able to google this error. I do not want to use Format as Table function.

Help, please?

Thanks for your prompt reply. It did accept this format of formula, but to no end, i.e. the formula is there, but it didn't change the selected cells (or any other for that matter) at all. I did select the cells I wanted to shade, chose Conditional Formatting, then chose New Formula -> use to choose cells to format, put it exactly as you wrote. Here's a screen:
notworking.png

Try again this time without the "=0" at the end; something like this =MOD(ROW(),2)

Note: use your semi-colon in place of the comma if needed.

@Ursul
Tried without the final "=0" at the end. Same effect. Putting a comma results in "invalid formula" prompt window, have to use semicolon. I have no idea why – I have a legit copy of Excel without any ingerention other than regular MS updates. I have retraced my steps yet again, yet could find no error on my side...