Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2014
    Posts
    3

    Unanswered: Conditional Formatting Problem

    In the attached spreadsheet I would like to have dates <today() be highlighted in red.

    But all the dates are highlighting rather than just the ones that are less than today.

    The column is formatted as a date and I'm using the conditional formatting tool but it's not working.

    Take a peek at the attached and tell me what I'm doing wrong.

    Total Equipment List.zip

  2. #2
    Join Date
    Sep 2014
    Posts
    37
    take the quotes off the rule

    cell value less than ="Today()" should be

    cell value less than =Today()

    -cheers

  3. #3
    Join Date
    Oct 2014
    Posts
    3
    Worked wonderfully, thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •