Solved

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

Posted on 2014-07-25
4
158 Views
Last Modified: 2014-07-30
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
Comment
Question by:morinia
4 Comments
 
LVL 23

Assisted Solution

by:NBVC
NBVC earned 150 total points
ID: 40220026
Try:

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

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

Assisted Solution

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

Accepted Solution

by:
Rob Henson earned 200 total points
ID: 40223869
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now