Clear cell value based on value of another cell

[Ahmed Albhnsawy]

Hi everyone,

1. I need to clear the contents in range of cells on the same row based on the value of another cell in the same row.

• My range is K26:P166,
• Range K:M only one cell should have value and clear contents of the others two cells,
• Range N:P clear contents depending on the cells have values of range K:M (for more details attached screenshot )

2. Can i using the VBA code with merged cells?

Any help would be greatly appreciated!!

 

[Peter_SSs]

Welcome to the MrExcel board!

Range K:M only one cell should have value and clear contents of the others two cells

Since your 3 columns K:M all have values, how should we decide which one to keep and which two to clear?

We would also no doubt need to know exactly what characters those ticks and crosses are.