IF and Conditional Formatting

Bobert

I have some conditional formatting set up so the field crew can make the needed measurements. I have a formula in the Delta column that adds up the measurements and subtracts that from the Qty for each column. I have an Automation that sends an email out if the Delta is above a certain threshold. I don't want the Delta computed until each measurement is made, so I am currently using the ISBLANK function to test if the cell has info. I have to create a formula for each type because each type has a different number of cells that need to be filled in. Is there a way to use the conditional formatting in an IF statement to prevent needing to use a different formula for each type?

Paul Newcome

Conditional formatting can only affect the formatting of a cell. It cannot affect the data.

Paul Newcome

Conditional formatting can only affect the formatting of a cell. It cannot affect the data.