Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • Last Modified:

Checking for a date > 05/31/2014 in conditional formatting in Excel 2010

Experts,

I have a date in column AF on a report.  I would like to highlight the row when the date in AF is > 05/31/2014.  What is the syntax to test for a date in conditional formatting?
0
morinia
Asked:
morinia
3 Solutions
 
NBVCCommented:
Try:

=$AF2>DATE(2014,5,31)

where AF2 is top most cell in AF that you selected to highlight.
0
 
als315Commented:
Rule should be (if rows start from 1, otherwise change $AF1 to first cell):
=$AF1>DATEVALUE("5/31/2014")
0
 
Rob HensonIT & Database AssistantCommented:
If you were to put the required comparison date (31 May 2014) in a cell, you can then use CF formula to compare with the cell.

For example, enter date in AG1 and formula would be:

=$AF2>$AG$1

You can then change the date as and when required without changing the Conditional Formatting.

Thanks
Rob H
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now