Conditional Formatting Help

Hello,

I was wondering if someone had a simple solution to my problem. I am looking to get numbers that I adjust or edit to automatically turn a color after I leave that cell.

For instance, for my work I write purchase orders and sometimes I make edits to these long purchase orders. I send the original order in all black text to the vendors but when I make edits I highlight the changes in red text. Rather than me clicking the red font button after every edit I complete, is there a more efficient way to do this process?

Thanks in advance!

Track Changes

I'm so surprised I can answer a question on here. This one's easy! You may just not have known what it was called or that it was even an available option. Just turn on track changes: https://support.office.com/en-gb/article/Track-changes-in-a-shared-workb...

Just skip the part about sharing the workbook. I think you can just track changes without sharing, but the sharing helps if you have multiple editors and tracking just helps period :).

Good luck and hope that this helps.

PS - This is also available in Word. Go crazy with it. I know I do.

Conditional Formatting Help

Hi,

There's a way, by writing a little bit of code in VBA.

Greetings,

Cheetahke