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
504 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 68

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
macro for active word document 4 39
macro for each dropdown 15 44
Hiding column macro 10 28
Need a Marquee for Windows 4 33
This collection of functions covers all the normal rounding methods of just about any numeric value.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

919 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now