Conditional protection

  • Thread starter Thread starter yorkeyite
  • Start date Start date
Y

yorkeyite

If I use the following formula to cout the Es in a rang
=COUNTIF(E15:E26,"E") I can use conditionsl formatting to advise peopl
making entries into that range if there not enough or too many.

is it possible to write some vb code that defaults the value of th
active cell to 0 if value of the countif function is >
 
Private Sub Worksheet_SelectionChange(ByVal Target As
Excel.Range)
If range("wherever the countif formula is").Value > 3 Then
ActiveCell.Value = 0
End If
End Sub
 
You must log in or register to reply here.

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

?Conditional protection 3
Conditional Formating 3
Excel Need Countifs Formula Help 0
loop help 6
Excel VBA formula call in VBA 1
If value occurs more than once then delete all of them 8
Range updates 1
Excel Named Ranges and Conditional Format 3

Back
Top