This sheet is a summary of data, time worked and reimbursable expenses (Hard Costs), collect from two (2) other sheets, based on forms filled out by employees and contractors. There are 12 project categories, "Clinical" is shown, each having 9 service categories and 15 expense categories. The other sheet should have those same values at A20 X G39. What I am trying to do is have a sheet that has skus, prices, and so forth and then when I add,delete, merge, color, or do anything to the cell on the "proposal creation" sheet I want it to mirror only a specific cells to another sheet that is "salesman copy" that we will print to clients. Nov 08, 2017 · Understand and master conditional formatting and see how to conditional format cells based on criteria that is also present in cell to boost productivity.

Mar 15, 2018 · The conditional formatting was gone, and the cells had a fill color instead. The colors were the same, but now Excel could extract the color number from those cells The macro would find the cell in the color list that matched the client's rank number, and use the color from that color list cell. Using Google Sheets for conditional formatting based on a range’s own values is simple. Formatting based on another range of cells’ values is a bit more involved. Following are step-by-step instructions to format a range of cells using values in another range of cells.