×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Linking a spreadsheet to calendar dates
2

Linking a spreadsheet to calendar dates

Linking a spreadsheet to calendar dates

(OP)
Is there a way to link an excel spreadsheet to a calendar date?

For example, have a cell turn red on a specific date?

Or even better, turn yellow five days BEFORE the "red" date?

I'm thinking of recurring tool calibration cycles.  

RE: Linking a spreadsheet to calendar dates

Enter =NOW() in the cell and the target date in another cell, then use conditional formatting to make it turn yellow when the cell value = target cell - 10 and red when cell value = target cell.

  

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
 

RE: Linking a spreadsheet to calendar dates

The solution is correct but uses another cell, which is not needed.
Use conditional formatting with Use Formula:
=A1>today()-10

This assuming your date is in A1. Keep the cell reference relative and you can paste this with the Format Painter to other cells.

Why an easy solution if you can make it complicated?
Greetings from the Netherlands

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources