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. ;)
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.
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)))
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.
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.
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.
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. ;)
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.
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)))
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.
Is your computer setup to use semi-colons instead of commas? Otherwise, I cannot see the problem with your formula... :(
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.
Excellent, thank you for the tip. How do I highlight a cell which contains odd numbers but less than 22?
Yes sir;
Thanks for your great insights, great job, totally clear and confident teaching your class, thanks.
Andy
I do not know how to count colors.
I am glad that it helped!
You are welcome!
Thanks buddy 😊
You are welcome!!!
wtf, zero is an even number
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.
Awesome tutorial with nice example
Thanks a lot for your kind effort
keep up good work
God bless you :-)
How do you modify this formula to not give you doubles and for it not to start at 1 instead of 0?
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
hey, great, but if you've got blanks in that range they are formatted just like the zero....
Nope, does not work for me. Excel keeps saying that there is an error in the function =MOD(A1,2)=0 :(
Highlight the details in green colour if customer ID start from even
Number
You will need some VBA. Post a question to the Mr Excel Message Board. Search for my video about this site.
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!
Same tutorial ms word 2007 make video please
I hope this is not too late: but this really saves my life!!!! 😎
Never too late : ) I am glad that the video helps, Syuhada!!
The result is every after 2minutes..
Got it!!