Conditional formatting maybe

[jacobfromso]

does anyone know how I can lock or unlock a cell based on a condition of another cell?

[VBA Noob]

This event macro lets you edit B1 if A1 equals yes

See what you think

VBA Noob

[DCSwearingen]

What "Kind" of condition are you talking about?

Use the Worksheet_Change event

   IF 'Your code for the condition to be met' THEN
            ActiveCell.Locked = False
   END IF

   IF NOT 'Your condition to be met'  THEN  
           ActiveCell.Locked = True
   END IF

Or substitute

Range(myCell).Locked = TRUE
Range(myCell).Locked = FALSE

if you want to lock (or unlock) a cell that is not the active cell.

[VBA Noob]

or

Change B1 to your range.
and change Named range RestritiveRange to your cell or range

Private Sub Worksheet_Change(ByVal Target As Range)
With ActiveSheet
        If Range("B1").Value = True Then
            .UsedRange.Cells.Locked = False
            .Range("RestritiveRange").Locked = True
            .Protect Password:="Secret"
        Else
            .Unprotect Password:="Secret"
        End If
    End With
End Sub

VBA Noob

[jacobfromso]

I should have added that I want to do this without a macro

[VBA Noob]

So why post under programming ??
Have you not read the rules below ??

VBA Noob

[jacobfromso]

Well - maybe an equation + conditional formatting???
My situation would be a piece of cake if conditional formatting would allow a cell to be lock or unlocked base on a condition