+ Reply to Thread
Results 1 to 4 of 4

If statement within conditional formating

  1. #1
    Registered User
    Join Date
    07-03-2012
    Location
    Florence, South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    10

    If statement within conditional formating

    Seems like this should be easy but I'm having trouble figuring out. In column "A" I have a list that ascends by one. I want odd numbered rows to have a gray background and even rows to have no change. Here's what I'm trying to do:

    A
    1 (gray background)
    1 (gray background)
    2 (white background)
    2 (white background)
    2 (white background)
    3 (gray background)
    3 (gray background)
    3 (gray background)
    3 (gray background)
    4 (white background)
    4 (white background)
    ect...

    Thanks in advance!

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: If statement within conditional formating

    Hi Steveseer,

    You can use IsODD function in condtional formatting formula, see attached :-
    Odd rows as grey.xlsx


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    07-03-2012
    Location
    Florence, South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: If statement within conditional formating

    Perfect - just what I needed, thanks!

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: If statement within conditional formating

    You are welcome steveseer..


    Cheers

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ 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