Solved

How do we make a due date stand out if it is less than 30-days away on a Microsoft Spreadsheet?

Posted on 2014-09-04
4
567 Views
Last Modified: 2014-09-17
We have a spreadsheet that lists the jobs that are pending.  It shows the title, due date, if completed Y/N, who is working on the project, etc.  What we would like is for the "Due Date" to turn from black to "BOLD" "RED", and "BLINK" whenever the listing is shown on the screen or printed.  When the field that indicates the the job has been completed with "Y" or a "completion Date is entered, the DUE DATE will return to its normal appearance.

Any suggestions that you can give will be appreciated.

sherman6789
0
Comment
Question by:sherman6789
[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
4 Comments
 
LVL 69

Accepted Solution

by:
Qlemo earned 500 total points
ID: 40304328
Please tell how you think to be able to print bold red and blinking on paper :D

Seriously, blinking is not supported in Excel. But bold and red can be done. The keyword is "Conditional Formatting".
Mark the cells to format, then select "Conditional Formatting" in the "Start" Ribbon.
Select "New Rule", then last open ("formula ...").
Then construct a boolean condition, which is like (If "completed" column is A, completion date is B, due date in C, and rows start at 2):
   AND(A2 <> "Y", B2 = "", C2-Today() < 30)
assign the desired format. You can also fill the cell with a colour, etc.
0
 
LVL 18

Expert Comment

by:Steven Harris
ID: 40304998
Qlemo is correct about using Conditional Formatting for this purpose.

As a fun note, blinking text is possible with VBA, although it is not very functional overall as you cannot edit a sheet while VBA is running.
0
 

Author Comment

by:sherman6789
ID: 40315591
Thank you Qlemo, Aikimark and Steven for your responses to my question.  I have been out of town and not able to respond.  I will begin working on this project immediately and respond to you soon.

Thanks again.

sherman6789
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
nested excel formula 5 29
find a word in a cell 3 39
keep the cell in the formula in excel 2013 5 25
VBA: copy range dynamically based on config sheet v3 6 23
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

735 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