[Webinar] Streamline your web hosting managementRegister Today

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

How to set a coditional date format in Excel ?

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
a500505077
Asked:
a500505077
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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