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