conditional formatting ISODD ISEVEN

[John_Whin]

Based on odd or even value in column A want to color cells in columns B - K.

If A1 is even want to color B1:K1 light green, if A1 is odd color B1:K1 darker green.
If A2 is even want to color B2:K2 light green, if A2 is odd color B2:K2 darker green.

Want to extend that formatting down whole sheet based on odd or even value in column A.

Thanks

 

[Fluff]

Select B1 to K last row > Conditional formatting > new Rule > Use a formula > =ISODD($A2) > select format.
The the same as above using
=ISEVEN($A2)

 

[John_Whin]

Thought it might be you Fluff, when I paint format down sheet it colors the cells before any value is in column A. how do I keep the cells B:K clear if column A is blank?

 

[Phuoc]

if column A is blank?

Try:
1. =ISODD($A2)
2. =AND(A2<>"",ISEVEN($A2))

 

[Fluff]

Change the Iseven formula to
=AND(ISEVEN($A2),$A2<>"")

 

[John_Whin]

Thanks Fluff, perfect as always!

 

[Fluff]

You're welcome & thanks for the feedback