Color Scheme does not meet the criteria in conditional formatting

[jewellove]

Please advise why the color scheme of some cells do not meet the criteria. I used conditional formatting where all odd ending number is light blue while even ending number is dark blue. I wander why there are cells where the ending is even number and the color is light blue. Please see the attachment for better understanding. Thank you...

[Fotis1991]

Change all your formulae to start in B2. Not in B3.

[mrice]

Suggest just two rules

=AND(ISODD($B1),$B1<>"")

and

=AND(ISEVEN($B1),$B1<>"")

Both apply to

=$A:$F

[Kevin UK]

Hi jewellove

See the attached, is that what you require!

[Teethless mama]

Don't do every single last value from 1 to 9. It's not elegant way to do.

=RIGHT($B3)+0=1
=RIGHT($B3)+0=2
...
...
...
=RIGHT($B3)+0=9

Try it like this:

Select your whole range. Conditional Formatting

=ISEVEN($B2) choose your color
or
=MOD($B2,2)=0



=ISODD($B2) choose another color
or
=MOD($B2,2)=1

[benishiryo]

hi jewellove, for odd numbers, this will do:
=MOD($B2;2)

can see that you've been working on all kinds of occasions.

[jewellove]

Beni,

hehehe.. Yes, I have deadline to meet. Please to let you know that my worksheet is done... Working on brief analysis.. Should be ready for submission tomorrow.. Thank you to all

hi jewellove, for odd numbers, this will do:
=MOD($B2;2)

can see that you've been working on all kinds of occasions.

[Kevin UK]

Hi jewellove

Thank you for the feed back.