Results 1 to 6 of 6

Problem with colouring the entire row based on odd or even number in the first cell

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2012
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Problem with colouring the entire row based on odd or even number in the first cell

    Hello, Excel gurus!

    I need help with conditional formatting. I wish Excel to colour the entire row green based on the condition that the number in the first cell of the row is odd. I have leafed through the forum answers here and have played with various formulas but the result that I get is weird no matter what I try. The latest example is this: Excel does colour some rows green but I have no idea how it chooses the rows to colour because they are neither odd nor even. I don't seem to understand what is happening there.

    Could anyone help please?
    Thanks in advance!
    Agnese
    Attached Files Attached Files
    Last edited by Agnese; 02-07-2012 at 11:02 AM.

Thread Information

Users Browsing this Thread

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

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