How do I program color into excel?

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?
 
J

Jim Thomlinson

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.
 
G

Gord Dibben

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
 

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 5
conditional formatting 2
Changing the color of a cell based on the color of another cell. 6
I want to change the cell format (color) based on a calc 4
Color row based on cell value 1
Conditional formatting, coloring the whole row 2
Using Excel to autopopulate color.. 3
Change Color of cell 3

Top