Ask a Question
or
Create a Poll
  1. Home /
  2. Questions /
  3. Computers
  4. / Computer Software
  5. / Spreadsheet Software
  6. / Microsoft Excel

by Ray on July 21st, 2009

Ray

Question

Help answer this question below.

I have two dates, one starting date and one ending date, there is a time line between the dates, if I go beyond the end date I would like the cell to turn Red, to indicate that I have gone beyond the ending date, what formula do I use to achieve this.

  • Like
  • Report
Share:
Other

Answers. 1 helpful answer below.

  • by Brian I on July 22nd, 2009

    Brian I

    Select the cell.
    Go to the Format... Conditional Formatting menu.
    Select 'Greater than' for the cell value and enter the ending date.
    Click on the Format button and select the colour you want.
    Click OK twice.

    • Like
    • Report

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

You're reading I have two dates, one starting date and one ending date, there is a time line between the dates, if I go beyond the end date I would like the cell to turn Red, to indicate that I have gone beyond the ending date, what formula do I use to achieve this.

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

ANSWERBAG BUZZ

How do i highlight a cell if a date fall betwen 2 dates
Secretly in love with another woman
How to enter two dates in one cell
Excel two dates in one cell

Answerbag

a Demand Media company