MrExcel Publishing
Your One Stop for Excel Tips & Solutions

pattern in even rows only

Posted by channyne on September 08, 2001 3:25 PM

i'm trying to have the even rows/cells shaded for quick viewing... any suggestions? if you do it manually (format/cells/patterns), then you add a row and perform a sort, the shaded cells follow the row. then the even rows are no longer shaded. thanks in advance for any help. (and i don't want to use the preformatted spreadsheets if possible)

Posted by Aladin Akyurek on September 08, 2001 3:50 PM

Select/activate the range of interest.
Activate Format|Conditional Formatting.
Select "Formula is" for "Condition 1" in the Conditional Formatting window.
Enter the following formula:


Activate the Format button.
Choose on the Patterns tab the color you want.
Click OK.


Posted by channyne on September 10, 2001 2:19 PM