| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making cells change color after a specified period of time.
Hi,
I'm looking for a way in excel to color cells on any dates that have elpased more then 30 days. Can anyone help me with this. Thanks for your help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Making cells change color after a specified period of time.
Use Conditional Formatting
Look Under Format, Conditional formatting --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Making cells change color after a specified period of time.
Marc,
You can use Conditional Formatting (CF) from the Format menu to do this. Open the CF dialog, change "Cell Value Is" to "Formula Is" and enter the following for the formula: =(TODAY()-A1)30 Change A1 to the address of the cell containing the date. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Marc" wrote in message ... Hi, I'm looking for a way in excel to color cells on any dates that have elpased more then 30 days. Can anyone help me with this. Thanks for your help |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Making cells change color after a specified period of time.
Cells will have a date and we want to change the color on
those cells with anyhting past 30 days from those dates in the cells -----Original Message----- Marc, You can use Conditional Formatting (CF) from the Format menu to do this. Open the CF dialog, change "Cell Value Is" to "Formula Is" and enter the following for the formula: =(TODAY()-A1)30 Change A1 to the address of the cell containing the date. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Marc" wrote in message ... Hi, I'm looking for a way in excel to color cells on any dates that have elpased more then 30 days. Can anyone help me with this. Thanks for your help . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do count blank cells between some period of time? | Excel Discussion (Misc queries) | |||
| Change font color when making changes | Excel Discussion (Misc queries) | |||
| average rate of change per given time period between 2 moments in time of a value | Excel Worksheet Functions | |||
| Change colour once a certain time period passed | Excel Discussion (Misc queries) | |||
| Changing text/color after a time period? | Excel Discussion (Misc queries) | |||
Linear Mode
