If your column has values in the cells A1:A8, to count even put this formula in a cell (not in conditional format box): =SUMPRODUCT(--(MOD(A1:A8,2)=0)) If your column has values in the cells A1:A8, to count odd put this formula in a cell (not in conditional format box): =SUMPRODUCT(--(MOD(A1:A8,2)))
Can you explain the data setup and what you are trying to do more clearly. For example give me the range that should get the Conditional Formatting and whether or not the formula should check if each cell is blank /or/zero or if it is the row that should be checked to see if the whole row is blank /or/zero and any other important details.
I was taught that zero was an even number, an even number is an odd number subtract 1. 1 minus 1 is 0, an even number. I was also taught that 0 is neither positive nor negative. Is this an excel thing or does 0 have a special rule separate from an even number is an odd number subtract 1?, Thanks for the great video and the head-scratcher.
I have a range of random numbers, including zeros and blanks that might get filled with a number some day. I needed one color for one set of the numbers and other for the other set of numbers, third color for zeros and blanks left :) Thanks for being interested in my problem. ;)
If you tell me the range is (like A1:G12) and what the criteria is for the two sets of numbers, I can give you the formulas for the Conditional Formatting.
Hello, how can I color several random numbers from a series, like, i want all numbers 7 48 25 32 17 to be red. and then again, other numbers in other colors, blue for numbers 4,16,19 without having the need to set a new rule for each number, like 7 red, go again and set rule for 48, etc. Thx
Is it possible to combine this with duplicate value formatting so that, for example, ONLY numbers with an ODD value and are duplicated are highlighted. I tried adding this to trick 514 but ALL duplicates and single ODD values were formatted. Regards.
Thanks buddy 😊
You are welcome!!!
You are welcome!
If your column has values in the cells A1:A8, to count even put this formula in a cell (not in conditional format box):
=SUMPRODUCT(--(MOD(A1:A8,2)=0))
If your column has values in the cells A1:A8, to count odd put this formula in a cell (not in conditional format box):
=SUMPRODUCT(--(MOD(A1:A8,2)))
Yes sir;
Thanks for your great insights, great job, totally clear and confident teaching your class, thanks.
Andy
Can you explain the data setup and what you are trying to do more clearly. For example give me the range that should get the Conditional Formatting and whether or not the formula should check if each cell is blank /or/zero or if it is the row that should be checked to see if the whole row is blank /or/zero and any other important details.
I am glad that it helped!
I was taught that zero was an even number, an even number is an odd number subtract 1. 1 minus 1 is 0, an even number. I was also taught that 0 is neither positive nor negative. Is this an excel thing or does 0 have a special rule separate from an even number is an odd number subtract 1?, Thanks for the great video and the head-scratcher.
I have a range of random numbers, including zeros and blanks that might get filled with a number some day. I needed one color for one set of the numbers and other for the other set of numbers, third color for zeros and blanks left :) Thanks for being interested in my problem. ;)
Is your computer setup to use semi-colons instead of commas? Otherwise, I cannot see the problem with your formula... :(
If you tell me the range is (like A1:G12) and what the criteria is for the two sets of numbers, I can give you the formulas for the Conditional Formatting.
Excellent, thank you for the tip. How do I highlight a cell which contains odd numbers but less than 22?
Awesome tutorial with nice example
Thanks a lot for your kind effort
keep up good work
God bless you :-)
Curious.... If I have a even number entered in cell B2, I would like cell B12 to divide the even number only from B2 then multiply that by 200.
I do not know how to count colors.
You will need some VBA. Post a question to the Mr Excel Message Board. Search for my video about this site.
Hello, how can I color several random numbers from a series, like, i want all numbers 7 48 25 32 17 to be red. and then again, other numbers in other colors, blue for numbers 4,16,19 without having the need to set a new rule for each number, like 7 red, go again and set rule for 48, etc. Thx
How do you modify this formula to not give you doubles and for it not to start at 1 instead of 0?
Is it possible to combine this with duplicate value formatting so that, for example, ONLY numbers with an ODD value and are duplicated are highlighted. I tried adding this to trick 514 but ALL duplicates and single ODD values were formatted.
Regards.
I've just found your AND function trick so that's answered my question!
@ExcelIsFun I already solved the problem, thanks!
I hope this is not too late: but this really saves my life!!!! 😎
Never too late : ) I am glad that the video helps, Syuhada!!
Highlight the details in green colour if customer ID start from even
Number
wtf, zero is an even number
hey, great, but if you've got blanks in that range they are formatted just like the zero....
Got it!!
Nope, does not work for me. Excel keeps saying that there is an error in the function =MOD(A1,2)=0 :(
Same tutorial ms word 2007 make video please
The result is every after 2minutes..