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

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