Locking cell
 

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

Locking cell
 

Short answer - No.

Pete

On Nov 1, 7:34 pm, whatzzup
wrote:
Good afternoon, is there a formula or condition formatting available to lock
cells if the font colour is specified?

Locking cell
 

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

"whatzzup" wrote:

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