+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting based on odd or even numbers

  1. #1
    Registered User
    Join Date
    12-13-2017
    Location
    canada
    MS-Off Ver
    2016
    Posts
    1

    Conditional Formatting based on odd or even numbers

    Hi, I need help with making a list of numbers from 1-100 in cells A1:A100 red or blue based on whether they are odd or even. I been searching a while, and nothing has come up. Also, if someone could explain how the "format conditions" is set up in excel 2013, that would be wonderful. I seem to be writing everything wrong. *Disclaimer* I started VBA a week ago

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Conditional Formatting based on odd or even numbers

    maybe
    select whole range
    in CF:
    =ISODD(A1)
    =ISEVEN(A1)

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Conditional Formatting based on odd or even numbers

    If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
    then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
    If you did it already - ignore it.
    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting based on list of numbers - select number 4000
    By uday1969 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-16-2017, 11:43 AM
  2. Replies: 1
    Last Post: 10-04-2016, 05:17 AM
  3. Replies: 1
    Last Post: 07-22-2016, 03:00 PM
  4. Replies: 5
    Last Post: 11-14-2015, 10:20 AM
  5. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  6. [SOLVED] Conditional formatting - formatting the lowest 2 numbers in a list of 12 numbers
    By ktbb0312 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-09-2013, 09:59 AM
  7. Replies: 9
    Last Post: 03-26-2012, 02:16 PM

Tags for this Thread

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