Locking cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good afternoon, is there a formula or condition formatting available to lock
cells if the font colour is specified?
 
Sub LockYellows()
Set MyRange = Range("B10:D20")
For Each c In MyRange
If c.Interior.ColorIndex = 6 Then
c.Locked = True
End If
Next c
Set MyRange = Nothing
End Sub
 

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

Question about conditional formatting of zeros in Excel 0
Cinditional formatting question - offsets 5
Lock range based on conditional format colour. 4
Font changed by Conditional Formatting 1
Excel 2003; Lost Cell Shading 3
Conditional formatting in Excel 2010 2
Conditional Formatting Font Change 1
format cells depending on value range 5

Back
Top