## apply conditional formatting formula every other row

My formatted row is now too crowded (confusing)

Current formulas.  Cells are dates

=IF((\$S9<>""),AND(\$S9=Z\$7,\$S9=Z\$7),FALSE)
=IF((\$S9<>""),AND(\$T9=Z\$7,\$T9=Z\$7),FALSE)
=IF((\$S9<>""),AND(\$U9=Z\$7,\$U9=Z\$7),FALSE)
=IF((\$S9<>""),AND(\$S9<=Z\$7,\$T9>=Z\$7),FALSE)

Trying to apply these formulas to format odd number rows starting at 9
=IF((\$S9<>""),AND(\$S9=Z\$7,\$S9=Z\$7),FALSE)
=IF((\$S9<>""),AND(\$U9=Z\$7,\$U9=Z\$7),FALSE)

Trying to apply these formulas to format even number rows starting at 10
=IF((\$S9<>""),AND(\$S9=Z\$7,\$S9=Z\$7),FALSE)
=IF((\$S9<>""),AND(\$U9=Z\$7,\$U9=Z\$7),FALSE)

Tried MOD...

## Keys to the Problem apply conditional formatting formula every other row

To apply different CF to odd and even rows, you can use:
=IF(MOD(ROW(),2)=0,TRUE,FALSE)
Now replace TRUE with the formula you want to use for CF for even rows, and replace FALSE with the CF formula you want to use for odd rows.
Hope that helps.
Cheers
Rich

## Windows Error Reporting - To Fix apply conditional formatting formula every other row

1. Go to Start button.
2. Open Control Panel.
3. Go to Windows Error Reporting.
4. Click on System and Maintenance, then click Problem Reports and Solutions.
5. Next, click Change Settings located on the left side panel of the Problem Reports and Solutions window.
6. Select an option to configure how you want Windows to look for a solution to your problems. You may allow Windows to do it automatically or ask you every time to check if problem occurs.
8. Select Off to turn off Error Reporting.

## Recommended Method to Repair the Problem: apply conditional formatting formula every other row:

### How to Fix apply conditional formatting formula every other row with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Run it, and it will scan your system. The junk files will be shown in the list. 2. After the scan is finished, you can see the errors and problems which need to be fixed. 3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair. 