Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formating (Excel 2000)

    I would like to shade every other row similar to old style computer printouts. I haven't thought of an easy to get this accomplished. I'd be grateful for any suggestions.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Conditional Formating (Excel 2000)

    See Andrew's macro <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=28285>here</A>. If this doesn't help, come back and ask.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formating (Excel 2000)

    Works great. Thanks

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: Conditional Formating (Excel 2000)

    An alternative or in addition to the suggestions, try this conditional format:

    =MOD(ROW(),2)=1

    and set the format pattern to a color of your choice.

  5. #5
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formating (Excel 2000)

    Thanks Kevin,

    That's the more along the lines of my original thinking. It's nice to have both ways to do it.

  6. #6
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Conditional Formating (Excel 2000)

    very elegant - without using VBA!
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Conditional Formating (Excel 2000)

    Wherre do you insert this?
    Thyanks,
    Jeff

  8. #8
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Conditional Formating (Excel 2000)

    Right in the Conditional Formatting Dialog - see picture
    Attached Images Attached Images
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  9. #9
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Conditional Formating (Excel 2000)

    I'm sorry, I wasn't clear; what I meant to as was where in the worksheet itself do you put the formula-i. e., cell A1?
    Thanks,
    Jeff

  10. #10
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Conditional Formating (Excel 2000)

    Every cell in the range to be formatted that way. No big deal, select the target area, and enter the conditional format formula applicable to the upper left cell of the selected range.
    -John ... I float in liquid gardens
    UTC -7ąDS

  11. #11
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formating (Excel 2000)

    THIS IS SO COOL! This should go into Tip & Trick type places all over. Maybe it is, but I haven't run across it before. <img src=/S/fanfare.gif border=0 alt=fanfare width=31 height=23> Thank you!

Posting Permissions

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