Results 1 to 6 of 6

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

Threaded View

  1. #1
    Registered User
    Join Date
    12-27-2013
    Location
    Washington
    MS-Off Ver
    Excel 2010
    Posts
    9

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

    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.
    Last edited by Johnington; 11-01-2014 at 04:30 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] IF date is greater than or equal to X but less than or equal to y
    By LloydGilmore in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-09-2019, 05:35 AM
  2. SumIfs containing a greater than or equal to And less than or equal to
    By teton88 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-15-2014, 07:47 PM
  3. [SOLVED] COUNTIFS function w/greater than or equal to, and less than or equal to time values
    By AliciaRenee in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-27-2014, 03:57 PM
  4. Scoresheet with Equal Ranks - need to identify equal placings separately
    By Caroleh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 02:59 AM
  5. [SOLVED] lower and upper case equal on spreadsheet but not equal in VB
    By don in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2005, 09:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1