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?