How to Fix: Why is there an error with this simple Excel formula using MOD and ROW()

The error you're experiencing with your Excel formula using MOD and ROW() is due to the way Excel interprets formulas. When you enter the formula =MOD(ROW(),2)=0, Excel thinks it's a string input rather than a formula because of the equals sign (=). This can be frustrating when trying to apply conditional formatting to a selection of rows.

This issue affects users who are new to using MOD and ROW() functions in Excel or those who are not familiar with how Excel handles formulas. However, it's also possible that experienced users may encounter this error if they're using an older version of Excel or have incorrect settings.

💡 Why You Are Getting This Error

• The main reason for this error is the way Excel interprets formulas when you enter them directly into a cell. When you start typing a formula, Excel assumes it's a string input unless you explicitly tell it otherwise by pressing Ctrl+Shift+= (or right-clicking and selecting 'Formula'). This means that if you simply type =MOD(ROW(),2) without the parentheses, Excel will treat it as a string input rather than a formula.
• An alternative reason for this error could be due to incorrect settings in your Excel preferences. If you have the 'AutoCorrect' option enabled, it may interfere with how Excel handles formulas. However, this is less likely to be the cause of the issue.

🚀 How to Resolve This Issue

💡 Conclusion

To summarize, the error you're experiencing is due to Excel's tendency to treat formulas as string inputs when entered directly into cells. By entering your formula using Ctrl+Shift+= (or right-clicking and selecting 'Formula'), or by disabling AutoCorrect, you should be able to fix this issue and apply conditional formatting to your selection of rows.