I created a conditional format in my report to fill the cell in red when this formula = TRUE.
<tbody>
</tbody>
=AND(B16<>B17,B16<>"",B17<>"") How do I apply this into a macro? I am adding a validation button that will confirm that this AND formula has been corrected. People will see the red but sometimes keep right on working through the report. I want the validation to stop them and make them change the cells value so the AND formula = FALSE. I have zero idea where to start. The cell I want to "validate" is "B16". Thanks all!!! |
<tbody>
</tbody>