Alternating row colors

[Paul B]

I know you can use =MOD(ROW(),2)=0 for Alternating row colors, but is there away to add and if statement to it to only alternate the row colors if there is something in column B? I tried =If(B:B>””,MOD(ROW(),2)=0) but that did not work. Thanks

 

[Guest]

On 2002-02-27 06:38, Paul B wrote:
I know you can use =MOD(ROW(),2)=0 for Alternating row colors, but is there away to add and if statement to it to only alternate the row colors if there is something in column B? I tried =If(B:B>””,MOD(ROW(),2)=0) but that did not work. Thanks

I assume that you're using Conditional Formatting on a selected row. Use a cell reference to the column B cell on that row. For example, =AND(NOT(ISBLANK($B2)),NOT(MOD(ROW(),2)))

 

[Paul B]

Thanks