+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting row if cell value in certain column is even

  1. #1
    Hyland Hunt
    Guest

    Conditional formatting row if cell value in certain column is even

    I'm fairly new to conditional formulas... I have a spreadsheet where one
    column has a list of numbers, when cell values in that column are even, I'd
    like to shade the entire row.

    I've managed to get the cell with the number shaded by just selecting the
    column with those numbers and using =MOD($A1,2)=0
    (The numbers that I'm checking for odd/even are in column A. The rest of
    the spreadsheet is text or dates).
    However, if I select the entire worksheet and enter that same formula, the
    entire worksheet gets shaded, which I don't understand.

    How do I shade the entire row when a conditional format finds a cell that
    meets what I've specified?

    Thanks!

  2. #2
    Ken Wright
    Guest

    Re: Conditional formatting row if cell value in certain column is even

    See your other post

    --
    Regards
    Ken....................... Microsoft MVP - Excel
    Sys Spec - Win XP Pro / XL 97/00/02/03

    ----------------------------------------------------------------------------
    It's easier to beg forgiveness than ask permission :-)
    ----------------------------------------------------------------------------

    "Hyland Hunt" <Hyland Hunt@discussions.microsoft.com> wrote in message
    news:25D39C04-AABD-478D-8E7C-2276D73886FE@microsoft.com...
    > I'm fairly new to conditional formulas... I have a spreadsheet where one
    > column has a list of numbers, when cell values in that column are even,

    I'd
    > like to shade the entire row.
    >
    > I've managed to get the cell with the number shaded by just selecting the
    > column with those numbers and using =MOD($A1,2)=0
    > (The numbers that I'm checking for odd/even are in column A. The rest of
    > the spreadsheet is text or dates).
    > However, if I select the entire worksheet and enter that same formula, the
    > entire worksheet gets shaded, which I don't understand.
    >
    > How do I shade the entire row when a conditional format finds a cell that
    > meets what I've specified?
    >
    > Thanks!




+ Reply to Thread

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