How do I program color into excel?

  • Thread starter Thread starter amievaj
  • Start date Start date
A

amievaj

I have a checklists created. When a due date is near, how do I set up a cell
to change into a color to inform me. For example, I have a list of license
with various due dates that must be updated every 4 years. As the due dates
nears or for licenses that are due now, I want the cell to change to red.
Can any one help?
 
Your description is a little thin. In general you can use conditional
formatting with a formula comparing the date in the cell to the current date.
If that is less than some threshold then colour the cell.
 
Conditional Formatting.

Assuming due date in A1

Formula is: =A1<TODAY()+8

Format to red pattern.

A1 will turn red when within 7 days of today.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting, coloring the whole row 2
Conditional Formatting 5
Changing the color of a cell based on the color of another cell. 6
Conditioanl formating 2
conditional formatting 2
Using Excel to autopopulate color.. 3
Conditional Formats 1
Excel Excel due and overdue date colours 2

Back
Top