Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing cell color if date is...
Hello,
How do i change the cell color in case the date in the cell is due after 3 months..?? and where i put the code if you give it to me... thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing cell color if date is...
You can use conditional formatting. Assuming your date cell in A1. Go to Menu-Click Format- Conditional Formatting Click formula is, and paste the formula into it. Then, go to format and format the way you want it, eg. go to the pattern tab to change the cell colour. =AND(DAY(TODAY())=DAY(A1),MONTH(TODAY())-MONTH(A1)=3,TODAY()-A1=90) If you have multiple cells, select all the cells by clicking on A1 then shift click the rest. Make sure A1 is selected, then conditional format it by putting in the same formula. The conditions above should be accurate enough to take care of most conditions. Enjoy. -- KellTainer ------------------------------------------------------------------------ KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322 View this thread: http://www.excelforum.com/showthread...hreadid=550750 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the color of a cell based on the color of another cell. | Excel Discussion (Misc queries) | |||
Cell colors or text color changing when date in cell gets closer. | Excel Worksheet Functions | |||
Changing color of single bar based on x-axis date value | Charts and Charting in Excel | |||
Changing color of line chart by date | Charts and Charting in Excel | |||
Changing a cell color based on date entry ... | Excel Programming |