none
Filter Date RRS feed

  • Question

  • Hi,

    I need help with VBA Macro. I want to change the A columns into blue IF F column contains "DE" and the AD column (Date) is today's date and after. 

    Thank you, 


    Friday, August 7, 2015 9:09 PM

All replies

  • You can use Conditional Formatting for that:

    • Select column A. I'll assume that A1 is the active cell in the selection.
    • On the Home tab of the ribbon, click Conditional Formatting > New Rule...
    • Select 'Use a formula to determine which cells to format'.
    • Enter the formula  =AND($F1="DE",$AD1>=TODAY())
    • Click Format...
    • Specify the formatting that you want in the Fill tab.
    • Click OK, then OK again.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Proposed as answer by ryguy72 Saturday, August 8, 2015 2:22 AM
    Friday, August 7, 2015 9:17 PM
  • Thank you for your reply. 

    However, it turns out that there is several dates that has different time zones.

    So my format timezone is "2015-08-07 CDT" and the other one is "2015-08-07 EDT". And my computer date time uses CDT.

    So If I use your formula, the date that has EDT isn't affected from the formula.

    Best, 

    Friday, August 7, 2015 9:40 PM
  • How are the dates stored? As text strings including the time zone?

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Friday, August 7, 2015 9:53 PM
  • It's custom format (yyyy-mm-dd hh:mm)
    Friday, August 7, 2015 9:56 PM
  • So how can we tell which time zone is used?

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Friday, August 7, 2015 10:00 PM
  • Yes. exactly
    Monday, August 10, 2015 4:43 PM