Conditional formatting

S

sampson

I need to have certain cells change color at a specific time. I enter a
date in a cell, say 30 days from today's date. Starting 10 days from today's
date till tomorrow, I need the cell to change to Yellow. From today & beyond
I need the cell to change to Red. Is this possible? I have over 250 cells
with dates and it would be much easier if the dates getting close to today's
date were highlighted. I would appreciate any and all help on this.

Thanks
Dennis
 
G

glen.e.mettler

Condition1
Formula - =A1<=TODAY()

Condition2
Formula - =(A1-TODAY())<10

Glen
 

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

PLEASE HELP! need conditional formatting related to date, blank cellsand today's date 16
Conditional Formatting 1
Unlock Cells on Condations 2
Help with formula 1
conditional formatting date and blank cell 3
Help with date formula and colour change 3
conditional formating and use of colorindex 1
Find Cell with Today's Date 4

Top