Less than but not equal to zero? Odd/Even but not equal to Zero?

[Johnington]

Hi all, I'm trying to create a roulette tracker and I'm using conditional formatting to color code the results based on small/big numbers, even/odd numbers, Red/Black numbers (see attached for sample).

Roulette tracker.xlsx

Problem is I would like to have the "0" Row displayed as a different color. I tried combining formulas but keep getting error messages and not quite sure what is wrong with my syntax. The formulas I'm currently using are.

For numbers less than 19:
=IF(A273<19,TRUE,FALSE)

For Even and Odd numbers
=ISEVEN(A273)

For Red and Black
=IF(IFERROR(MOD(FIND(TEXT(A273,"00"),"02.04.06.08.10.11.13.15.17.20.22.24.26.28.29.31.33.35."),3)=1,FALSE),TRUE,FALSE)

So I need to append these formulas (or perhaps use completely different ones) to include a third element for "0" which would display something other than "TRUE" or "FALSE"

Thanks for any suggestions.

[etaf]

if you are using conditional format
just set up the first rule
as
=A273 = 0
then use stop if true

Also
you dont need the IF as conditional formatting is already setting for a true condition
so
=A273<19

Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Johnington]

Thanks for the quick response, I did attach a sample (inline) maybe it only works when I click on it? I'll try the attachment again.

[etaf]

sorry, missed that

have a look at the attached
i have used A as the reference but added the conditional format in K,J,L

may have the colours slightly wrong

[Johnington]

Thanks, this appears to work, the colors are insignificant as long as they are consistent. Appreciate the help and repped.

[etaf]

your welcome thanks for the rep