Highlighted fill cells -

[steve89]

wondering if i have highlighted cells so just like accounting one row is white the next one is gray and so on. But if i delete a row how can i make sure that pattern continues?

 

[Joe4]

Use Conditional Formatting. Highlight the rows you want to apply it to and use this formula:

=ISODD(ROW())

and choose your gray fill option.

 

[steve89]

thank you for the quick replay so i have cells A4:AE100 and every other row is white and then gray i entered this formula in conditional but maybe not in the right place because when i deleted the row its turned anything under that deleted row to gray.

 

[Joe4]

Remove everything that you have now that is coloring the rows, and replace it with the Conditional Formatting formula, exactly as-is (make no modifications to my formula).

Note: Another way you can accomplish this is to set up your range as a Table in Excel, which automatically alternates color rows.

 

[steve89]

thank you so much for your help works perfectly : )

 

[Mister H]

Have a look at this and see if it helps

https://stackoverflow.com/questions/4629100/excel-vba-alternate-row-colors-in-range

 

[Joe4]

You are welcome!

 

[steve89]

question even though it works i have an issue -- i have conditional formulas there's and need them to change color when appropriate but the formula you gave me doesn't allow that any ideas?

 

[Joe4]

Are you saying that you have other conditional formatting rules that should take precedence over this one?
If so, then under Conditional Formatting, go to "Manage Rules", and order them so that the other rules are at the top, and check the "Stop If True" check box.

 

[steve89]

thank you that works perfectly