Solved

Excel conditional formatting compare entered date with today's date

Posted on 2007-03-28
2
526 Views
Last Modified: 2008-02-01
In Excel I need a conditional formatting where when entering a date, it compares it with today's date, and when it's earlier than today's date, change the fill color to red. How do I do it?
0
Comment
Question by:HKBoyz
2 Comments
 
LVL 80

Accepted Solution

by:
byundt earned 250 total points
ID: 18813567
Use the Formula Is criteria with something like:
=AND(A1<>"",A1<TODAY())               assuming that A1 is the top left cell in the selection
The fill color is found on the Patterns tab
0
 

Author Comment

by:HKBoyz
ID: 18813609
Works for me. Thx.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

760 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

20 Experts available now in Live!

Get 1:1 Help Now