compare date

  1. C

    Compare given date to today's date

    I am looking for a simple code in VBA that compares a given date of a cell (cells(x,2)) to today's date. If the difference between the two dates is less than or equal to 3 days, I want to change the background color of cells(x,2) to red. I have used conditional formatting before but, I want to...
  2. D

    Conditional Formatting Duplicates based on Date Comparisons

    I apologize if this has been answered elsewhere, but searching didn't turn it up. My spreadsheet is setup in this manner (only showing columns needed for evaluation): Date | Name What I need to do is apply a format to a row only if the value in the Name column is duplicated in the table, and...

Some videos you may like

This Week's Hot Topics

Top