Add Change Find Or Clear Conditional. Finally I also searched this forum for Conditional Format which provided a few useful links. Our formula is E3Pending It will analyze each cell in a row no4.
This will erase all cell formatting including conditional formatting number formats fonts colors borders etc but keep the cell contents. Execute command2 only if command1 fails OR command1 command2. Our formula is E3Pending It will analyze each cell in a row no4.
Like case 1 but change formula in Find what13Header begining13 Type in Replace with boxp Then click Find next to manual fix if you see each find result is different or click Replace all if you think all result are the same.
Starts from Cell A4 will check whether the cell E4 has the delivery Status Pending or not. Execute command1 and then execute command2 AND command1 command2. You can then apply an IF condition to replace those values with zeros as in the example below. I want to see how much each Salesperson sold.
