Color manually entered values red for D6:D thru J6:J.

[mikeburg]

I have formulas in columns D thru J starting with row 6. Any values the formulas return in the cells are colored in black.

Need VBA sheet change code to color red any values manually entered in range D6:D thru J6:J.

The result for the range D6:D thru J6:J should be:
Values returned by formulas are in black.
Values manually entered over the formulas are in red.

Please help. Thank you. mikeburg

 

[Andrew Poulsom]

Maybe you can use this:

http://www.mrexcel.com/board2/viewtopic.php?t=156901

 

[mikeburg]

Thank you. mikeburg