Hello all,
So I tried asking a related question yesterday, but I think I may have gone about my solution incorrecly. So instead I am going to try a new approach.

Description: I want to keep track of active clients (new and existing) during a several-step process. Some of these processes are shared across new and existing clients, and some are unique to the type of client. I currently use conditional formatting to distinguish between processes: Red ("1") means a process is necessary but not yet complete, Green ("0") means a process is necessary and complete, and Black ("") means a processess is unnecessary (i.e., it is unique to new but not existing clients and vice versa). Employees keep track of clients by changing the column value from red to green (i.e., replacing a "1" with a "0" from left to right) and after the last process is finished simply delete the record (row).

Goal: I want to be able to, when I add a new client, automatically insert 1's, and 0's based on the value of my first column (which IDs clients as either "New" or "Existing"). So after the value of Column A is changed (from blank to either "New" or "Existing"), 1s and 0s need to be inserted into particular columns within that row. Any help would be greatly appreciated.

My current columns look like this:

"Client Type" | Process A | Process B | Process C...