Conditional Formatting IF Statement for Odd/Even

[JTL9161]

I am trying to write a conditional formatting with an if statement

I have 2 rows of numbers (Row 1 Col A-Q and Row 2 A-Q)

I have a 3rd row (Row 4) with odd/even numbers.

What I am trying to write is IF (CELL A4 IS ODD then just highlight the cell A1) and IF (CELL A4 IS EVEN then just highlight the cell A2)

Everything I see online is highlighting the number using ISEVEN and ISODD.

Thank you in advance,
James

 

[Joe4]

If I am understanding you correctly (I am note sure what part rows 1 and 2 play in this), you should just need two Conditional Formatting rules.

First, one on cell A1 with the Conditional Formatting formula of:

=ISODD(A4)

and then one on cell A2 with the Conditional Formatting formula of:

=ISEVEN(A4)

 

[BigBeachBananas]

Try:

Book1
	A	B	C	D
1	highlight if odd	highlight if odd	highlight if odd	highlight if odd
2	highlight of even	highlight of even	highlight of even	highlight of even
3
4	7	32	14	5
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:D2	Expression	=MOD(A4,2)<>0	text	NO
A1:D1	Expression	=MOD(A4,2)=0	text	NO

 

[Joe4]

Try:

Book1
	A	B	C	D
1	highlight if odd	highlight if odd	highlight if odd	highlight if odd
2	highlight of even	highlight of even	highlight of even	highlight of even
3
4	7	32	14	5
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:D2	Expression	=MOD(A4,2)<>0	text	NO
A1:D1	Expression	=MOD(A4,2)=0	text	NO

No need to use the MOD function, as Excel already has an ISEVEN and ISODD functions (no sense in recreating the wheel).

 

[BigBeachBananas]

No need to use the MOD function, as Excel already has an ISEVEN and ISODD functions (no sense in recreating the wheel).

Yes, you're correct. those functions slipped my mind.

 

[Joe4]

Yes, you're correct. those functions slipped my mind.

Might be time for a break (the OP actually mentioned those functions in the original post)!
I have been known to do this too, and I have to remind myself to step away from the computer from time-to-time!

 

[JTL9161]

Thank you both for your input. I will give them a try.