Excel: Highlight cell based on another cell : I don't know if this would be possible so I am going to ask.  If a value in column D changes (Column D contains wage rates) then highlight in that same row cell K Column K has a formula based on column D.  

For example if D4 is updated with new wage rate then highlight K4.

Thank you in advanced for your help.
