Clear cell contents if greater or less than another cell

[bar807]

Cannot find a VBA for the below maybe someone can please help out

I have 2 column ranges (F11:F74) and H11:H74) filled with different numbers. In cell X10 I have a value that changes dynamically based on conditions in another sheet. What I need to achieve is to clear the contents in the above ranges (F and H) which are lower than the value in cell X10

[Richard Buttrey]

Hi,

A macro won't react to a cell with a formula that happens to change value. You would need to attach the following macro to a button or trigger it witrh some other event procedure

Please Login or Register  to view this content.

Change the VBA Sheet1 code name as necessary.

[mehmetcik]

Right Click on your sheet name at the bottom of excel and select view code

Paste this code into the module that opens and close the module.

This will run a macro whenever X10 is changed and will do what you want.

However. 1. It will overwrite H11 to J74
2. It will run whenever the spreadsheet recalculates so might slow you down.
3. It would be better if you could specify which cell you want to change manually to trigger the macro.
4. Run the Macro "Reset" if the Macro stops working.

I cannot post the Macro so a sample is attached.

[bar807]

Hello Richard,

Thanks for your feedback. Seems to be working good. Is there a way I can edit it so only the values are cleared but not formatting?

Thanks
Charles