Solved

How to set a coditional date format in Excel ?

Posted on 2014-12-27
2
99 Views
Last Modified: 2014-12-27
Dears,

I want to set a conditional date format to show Expiry date (older than today) in Red; future date in black.

Thanx
16.09.01.xlsx
0
Comment
Question by:a500505077
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 500 total points
ID: 40520242
Hello,

since all your dates are already red, you need a conditional format to turn the ones in the future to black. To do that

- select all the data in column A, from row 1 to the last row (558)
- on the Home ribbon click "Conditional Formatting > New Rule"
- Select "Use a formula to determine..."
- enter this formula:

=A1>TODAY()

- click the "Format" button and set a black font color.
- click OK in all dialogs.

cheers, teylyn
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
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…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

734 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