I want to create a conditional format rule in Google Sheets such that even cells in a specified range are formatted a particular color if they are blank.
I attempted the following:
- Select Format
- Select Conditional formatting...
- Conditional format rules bar appears as bar in left-hand side of window
- Enter a specific column range in Apply to range field
- Select Custom formula is in Format cells if... dropdown menu
- Enter "=ISBLANK(ISEVEN(ROW()))" in custom field directly below Format cells if... dropdown
- Enter a custom color as Formatting style
- Select Done button
Unfortunately, the custom formatting does not appear in the specified range after creating the conditional formatting rule.
See screenshot for additional clarification.