<div>
Qlemo is correct about using Conditional Formatting for this purpose.<br />
<br />
As a fun note, blinking text <b><i>is</i></b> possible with VBA, although it is not very functional overall as you cannot edit a sheet while VBA is running.
</div>


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.

<div>
Thank you Qlemo, Aikimark and Steven for your responses to my question. &nbsp;I have been out of town and not able to respond. &nbsp;I will begin working on this project immediately and respond to you soon.<br />
<br />
Thanks again.<br />
<br />
sherman6789
</div>


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

<div>
<div class="content wysiwyg-content">
We have a spreadsheet that lists the jobs that are pending. &nbsp;It shows the title, due date, if completed Y/N, who is working on the project, etc. &nbsp;What we would like is for the &quot;Due Date&quot; to turn from black to &quot;BOLD&quot; &quot;RED&quot;, and &quot;BLINK&quot; whenever the listing is shown on the screen or printed. &nbsp;When the field that indicates the the job has been completed with &quot;Y&quot; or a &quot;completion Date is entered, the DUE DATE will return to its normal appearance.<br />
<br />
Any suggestions that you can give will be appreciated.<br />
<br />
sherman6789
</div>
</div>


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

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.

Office Productivity

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.