Use the ISODD and COLUMN functions to determine odd columns
In this example, we want to determine whether a column’s index in a range is even or odd, and then fill each odd row with the character “X”. Use the ISODD function in combination with IF and COLUMN() to get the result shown in the image below. If this function is not available and returns [...]
