Go Premium for a chance to win a PS4. Enter to Win

x
?
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
Medium Priority
?
583 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
3 Comments
 
LVL 71

Accepted Solution

by:
Qlemo earned 2000 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

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

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

The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
Gain an elementary understanding of Blockchain technology.
Integration Management Part 2
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…

772 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