date text to change colour when it gets over six months

N

Nessa

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
 
J

Jacob Skaria

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 Format>Conditional Formatting>

3. For Condition1>Select 'Formula Is' and enter the below formula
=DATEDIF(A1,TODAY(),"m")>=6

4. Click Format Button>select the formatting

5. Hit OK

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to edit colours already saved as part of a custom theme? 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Excel does not accept text format! 0
I have lost 6 months work, how can i get my file back 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Word OLE to check spelling in text box 1
How to paste this down? 3
Generated text copies into another template 0

Top