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