| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date text to change colour when it gets over six months
Working in excel table, I would like to get the text to change colour
automatically once it has been on the table for over six months |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
date text to change colour when it gets over six months
1. Select the cell/Range (say A1:A10). Please note that the cell reference A1
mentioned in the formula is the active cell in the selection. Active cell will have a white background even after selection 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =DATEDIF(A1,TODAY(),"m")=6 4. Click Format Buttonselect the formatting 5. Hit OK If this post helps click Yes --------------- Jacob Skaria "Nessa" wrote: Working in excel table, I would like to get the text to change colour automatically once it has been on the table for over six months |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change cell colour according to date..... | Excel Worksheet Functions | |||
| change text colour | New Users to Excel | |||
| Change colour based on date | Excel Worksheet Functions | |||
| Change cell colour by date | New Users to Excel | |||
| Change Colour OF Text??? | Excel Discussion (Misc queries) | |||
Linear Mode
