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
562 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
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

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

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

Suggested Solutions

This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

856 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