Solved

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

Posted on 2014-07-25
157 Views
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
Question by:morinia

LVL 23

Assisted Solution

NBVC earned 150 total points
Try:

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

where AF2 is top most cell in AF that you selected to highlight.
0

LVL 39

Assisted Solution

als315 earned 150 total points
Rule should be (if rows start from 1, otherwise change \$AF1 to first cell):
=\$AF1>DATEVALUE("5/31/2014")
0

LVL 31

Accepted Solution

Rob Henson earned 200 total points
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

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Datâ€¦
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns overâ€¦