+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Conditional Formatting For Date Value (adjacent cells to be formatted too)

Hybrid View

shez_raz Conditional Formatting For... 06-19-2012, 02:53 AM
dip11 Re: Conditional Formatting... 06-19-2012, 06:22 AM
Pepe Le Mokko Re: Conditional Formatting... 06-19-2012, 07:48 AM
shez_raz Re: Conditional Formatting... 06-19-2012, 09:56 PM
  1. 06-19-2012, 02:53 AM #1
    shez_raz is offline
    Registered User
    Join Date
    04-04-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    10

    Conditional Formatting For Date Value (adjacent cells to be formatted too)

    Hello!

    I have a list of start and end dates, and I want to shade all data in that row which contain similar start/end dates.

    Have attached my excel, column A to D contain the raw data. Column G-J is how I want the data to look like without having to do it manually.

    Is it possible?

    Thank you!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-19-2012, 06:22 AM #2
    dip11 is offline
    Valued Forum Contributor
    Join Date
    06-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    341

    Re: Conditional Formatting For Date Value (adjacent cells to be formatted too)

    Use this formula:
    =$C2-$B2<5
    Then modify this VBA to fill it down:
    http://www.excelforum.com/showthread...=1#post2786028
    Last edited by dip11; 06-19-2012 at 06:25 AM.
    Reply With QuoteRegister To Reply
  3. 06-19-2012, 07:48 AM #3
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,605

    Re: Conditional Formatting For Date Value (adjacent cells to be formatted too)

    =$C2-$B2<5 will return FALSE or TRUE depending on the value of B2, not on the difference between B2 and C2

    You should use parenthesis 
    =($C2-$B2)<5
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  4. 06-19-2012, 09:56 PM #4
    shez_raz is offline
    Registered User
    Join Date
    04-04-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Conditional Formatting For Date Value (adjacent cells to be formatted too)

    Hi Dip11 & Pepe Le Mokko,

    Thanks for the links and tips, shall try my best to work it out with my limited excel/VBA skills! :D
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1