Samgraphics
New Member
 Joined
 Jan 9, 2022
 Messages
 42
 Office Version

 2011
 Platform

 MacOS
HI,
So I’m trying to find a more efficient way to achieve this results. I used an if an function to see if the value in a cell is an odd or an even number and is less than ten. If it is it will highlight that cell with the color I choose. I made the column letter absolute so that I can copy the formula down the column. But I also want it to check that same column to see if the value is odd and greater than 10, is even and less than ten and is even and greater than ten and apply a specific background color for which ever is true. So that requires four different formulas. Not only that but I want it to do that for an array of 5 numbers, one in each column. So in total I have to write that formula 20 times for one row. I’m using excel’s conditional formatting to achieve this with the use formula to determine results option. The good thing is I can then copy it down to all the other arrays of numbers. I’m just worried that it will make excel run too slow since I have over 300,000 arrays of numbers.
In addition each cell has another formula that checks to see if the value is odd or even and less than or greater than 10 and adds a text string of odd or even in each each column using the if and formula.
Also in a separate two columns I’m using sumproduct(mod()) to check how many odds and evens there are in the row.
I tried to upload a minisheet but it didn't work on my mac.
Is there a more efficient way to accomplish this?
Thanks in advance
So I’m trying to find a more efficient way to achieve this results. I used an if an function to see if the value in a cell is an odd or an even number and is less than ten. If it is it will highlight that cell with the color I choose. I made the column letter absolute so that I can copy the formula down the column. But I also want it to check that same column to see if the value is odd and greater than 10, is even and less than ten and is even and greater than ten and apply a specific background color for which ever is true. So that requires four different formulas. Not only that but I want it to do that for an array of 5 numbers, one in each column. So in total I have to write that formula 20 times for one row. I’m using excel’s conditional formatting to achieve this with the use formula to determine results option. The good thing is I can then copy it down to all the other arrays of numbers. I’m just worried that it will make excel run too slow since I have over 300,000 arrays of numbers.
In addition each cell has another formula that checks to see if the value is odd or even and less than or greater than 10 and adds a text string of odd or even in each each column using the if and formula.
Also in a separate two columns I’m using sumproduct(mod()) to check how many odds and evens there are in the row.
I tried to upload a minisheet but it didn't work on my mac.
Is there a more efficient way to accomplish this?
Thanks in advance