Conditional Formatting to shade alternate Rows.

[omairhe]

Hey everyone,

Recently I came across a solution for shading alternate rows using Conditional Formatting. For example

=MOD(ROW(),2)=0​

However, instead of shading an entire row, I want to shade from Column A to up until Column L.

Would that be possible?

Will appreciate any help, thank you.

 

[aqeelnokia99]

=mod(column(),2)=0

 

[rlv01]

Just limit the range you are applying the format condition to columns A:L.

 

[aqeelnokia99]

select colom A:L then click condation formation then add rule also i add screen shot if want to do that add 1 more formula
=AND(MOD(COLUMN(),2)=0,MOD(ROW(),2)=0)

 

[omairhe]

Thank you..

 

[My Aswer Is This]

This is interesting. I never use conditional formatting. But I tested this and it is interesting.