With DocHub, you can easily rework formula in WPD from any place. Enjoy capabilities like drag and drop fields, editable text, images, and comments. You can collect electronic signatures securely, add an extra layer of protection with an Encrypted Folder, and work together with teammates in real-time through your DocHub account. Make adjustments to your WPD files online without downloading, scanning, printing or mailing anything.
You can find your edited record in the Documents tab of your account. Prepare, submit, print out, or turn your file into a reusable template. Considering the variety of powerful features, it’s easy to enjoy effortless document editing and management with DocHub.
Take this table as an example. We can use the formula to set the conditional formatting by ourselves and mark the finished projects. Select the cell range A2:C22, and get into the amp;quot;Homeamp;quot; tab. Click the amp;quot;Conditional Formattingamp;quot; drop-down button, and choose the amp;quot;New Ruleamp;quot; option. In the pop-up dialog, we choose the amp;quot;Use a formula to determine which cells to formatamp;quot; option. In the amp;quot;Format only cells withamp;quot; edit box, enter the formula amp;quot;=$C2=amp;quot;Finishedamp;quot; amp;quot;. The absolute reference has been added to the column label to prevent the data in column C from moving. The row number does not add an absolute reference so that it will change into $C2, $C3, $C4 with the selected data area. Then, we click the amp;quot;Formatamp;quot; button to open the amp;quot;Format Cellsamp;quot; dialog, switch to the amp;quot;Patternsamp;quot; option, select a favorite fill color, and click