Locking cell

[whatzzup]

Good afternoon, is there a formula or condition formatting available to lock
cells if the font colour is specified?

 

[Pete_UK]

Short answer - No.

Pete

 

[Jim May]

Sub LockYellows()
Set MyRange = Range("B1020")
For Each c In MyRange
If c.Interior.ColorIndex = 6 Then
c.Locked = True
End If
Next c
Set MyRange = Nothing
End Sub