Excel VBA - Change cell color with Colorindex value

In this video tutorial, you'll see how to change background and font color of cells in a finite range as user enters any value into the cell.

Feel free to write to me if you have any queries.

[mofojackson]

My friend this is so great! Thank you! :)

[kpkaus]

I am trying to write a VBA Function code to highlight Odd and Even numbers. But not having much luck. Can you help me, please?

I would like to use the following condition to highlight a cell:

=AND(ISODD(A1), A1<24) for Low-Odds
=AND(ISODD(A1), A1>24) for Low-Evens
=AND(ISEVEN(A1), A1<23) for High-Odds
=AND(ISEVEN(A1), A1>23) for High-Evens