Clear contents of cells if a condition is met

B

bevchapman

I am trying to come up with a formula that will clear the contents in a range
of cells if another cell contains an X on the same row. Any suggestions?
 
M

Mike H

Hi,

You cant have a formula in (say) A1 along the lines of

=if(b1="x",c1="")

you could do this in A1

=IF(B1="x","","No x")

which leaves A1 blank if there's an X in B1 otherwise you need a macro

Mike
 
G

Gord Dibben

Formulas can return values to the cells in which they are written.

They cannot clear contents of another cell.

Are you ready for VBA?

Sub Clear_Stuff()
Dim rng As Range
With Selection
For Each rng In Selection
If rng.Value = "x" Then
rng.EntireRow.ClearContents
End If
Next rng
End With
End Sub


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

return blank cell if condition met 2
Returning 1 of 4 values if conditions are met 4
Macro clear cells if meet 1 condition 8
If then Statements in Excel 4
Clear Contents Of Cells Where Value = 0 3
Excel VBA 1
clear unlocked cells macro help please 3
using button to clear contents 2

Top