JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
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
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