Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Copy Conditional Formatting Of Control. It must return TRUE for conditional formatting to be applied. In the Navigation Pane right-click the form or report that you want to change and then click Layout viewor Design view.
Click Kutools Insert AutoText to activate the AutoText pane. In the Navigation Pane right-click the form or report that you want to change and then click Layout viewor Design view. Click the control to.
Select the destination range which in this case is C3C14.
While copying or auto-fill the condition in conditional formatting the reference cell remains a constant which becomes a hurdle when you want to apply a variable condition. The good thing is that you can copy the conditional formatting rule that has applied. Go to Home tab Format painter. In the Navigation Pane right-click the form or report that you want to change and then click Layout view or Design.