Conditional formatting formula to highlight/shade every other row

[avidcat]

Sample attached.

I am using the following formula in conditional formatting but was wondering if it could be altered to also highlight/shade every other row?

=NOT(ISBLANK($A2))

I am using this so that when an entry in made in column A, the row will display a border around each cell. I wanted to see if it was possible to also shade every other row and an entry is made into column A.

Thanks,
Nick

[teylyn]

Hello,

create a second formatting rule for the same range. With the cursor located in A2, the formula for the rule is

=AND(NOT(ISBLANK($A2)),MOD(ROW(),2))

select a fill color and OK.

cheers,

[Richard Buttrey]

Hi,

You could add a second conditional format in A2 covering the same range and use an appropriate Fill colour

Please Login or Register  to view this content.

However don't forget that with Excel 2007 onwards if you use Insert Table and select the range ("A2:N32") you can then use the Table Tools Design and pick one of the 'pyjama stripe' themes which will automatically shade every other row.

[avidcat]

Perfect!

Thanks for your help.