|
|
#1
04-24-2019, 07:14 AM
|
|||
|
|||
Conditional Formatting date change "Y"
I have Three columns
G is Total Years of Experience Formula is =DATEDIF(H2,$M$5,"Y")+I2 H is hire Date - Just date I is Prior Years of Experience - Just Date and M is Today Date =TODAY() I want to do a conditional formatting that every time a number change in G column to highlight that cell Thanks in advance! 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N | mikey386 | Excel | 2 | 12-11-2014 01:14 PM |
 Numbering format not "tracked" in track changes w/ formatting "on."
|
Velocitydreamer | Word | 1 | 05-26-2013 07:04 AM |
| Conditional formatting - "From" - Why does it recognise only names and not emails | ghumdinger | Outlook | 0 | 09-18-2011 01:28 AM |
| How do I change the "and" to "or" with multiple Rules (and Alerts)? | bschimmel | Outlook | 0 | 11-16-2009 05:26 AM |
|
I need help with "Conditional Formatting"
|
tgorrie | Excel | 1 | 02-28-2006 12:18 PM |
Windows 10 
Office 2016
Threaded Mode