Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Alternating row colors

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I know you can use =MOD(ROW(),2)=0 for Alternating row colors, but is there away to add and if statement to it to only alternate the row colors if there is something in column B? I tried =If(B:B>,MOD(ROW(),2)=0) but that did not work. Thanks

  2. #2
    Guest

    Default

    On 2002-02-27 06:38, Paul B wrote:
    I know you can use =MOD(ROW(),2)=0 for Alternating row colors, but is there away to add and if statement to it to only alternate the row colors if there is something in column B? I tried =If(B:B>,MOD(ROW(),2)=0) but that did not work. Thanks
    I assume that you're using Conditional Formatting on a selected row. Use a cell reference to the column B cell on that row. For example, =AND(NOT(ISBLANK($B2)),NOT(MOD(ROW(),2)))

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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