+ Reply to Thread
Results 1 to 5 of 5

highlighting a row based on cell value

  1. #1
    Registered User
    Join Date
    05-06-2009
    Location
    usa
    MS-Off Ver
    2016,365
    Posts
    13

    highlighting a row based on cell value

    Column A is all random dates . When the date happens on the 1st I need to highlight that row. I'm pretty sure conditional formatting is the way I need to go but have had no luck. The date format is dd/mm/yy.
    Last edited by Castarmax; 05-06-2009 at 03:42 PM.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: highlighting a row based on cell value

    conditional format
    formula is
    =DAY($A1)=1
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Contributor
    Join Date
    05-04-2009
    Location
    ME
    MS-Off Ver
    Excel 2003,2007
    Posts
    157

    Re: highlighting a row based on cell value

    its cool... thanks a lot

  4. #4
    Registered User
    Join Date
    05-06-2009
    Location
    usa
    MS-Off Ver
    2016,365
    Posts
    13

    Re: highlighting a row based on cell value

    Works great Thanks.
    Can I expand that to only highlight columns say A-J?

  5. #5
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: highlighting a row based on cell value

    select cells columns a to j then apply the format to the lot
    best if you only go down as far as rows you think you'll need otherwise you will applying it to 1000000 or so rows!

+ 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