How color of cells change automatically with change of date.

September 11, 2016 at 21:19:59
Specs: Windows 7
How color of cell automatically change with change of date. Say I have bunch of numbers, and each number has certain date of occurrence/arival, and if date exceed say <= 10 days, than color would be orange, if date is passed 20 days color would be green and if it passed more than 30 days color would deep Red. And this color will be change automatically with change of date? How do I do this in excel?

message edited by SantanuBiswas


See More: How color of cells change automatically with change of date.

Reply ↓  Report •


#1
September 12, 2016 at 02:00:18
See this How-To

http://www.computing.net/howtos/sho...

And, Excel questions are best asked in the Office Software forum.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •
Related Solutions


Ask Question