Hi,

And some more stuff:

If you want a toggle macro to apply conditional formatting to some selected
cells if they are locked:

Sub ColorMyLocked()
With Selection
If .FormatConditions.Count 0 Then
.FormatConditions.Delete
Else
.FormatConditions.Delete
.FormatConditions(1).Interior.ColorIndex = 38
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression,
Formula1:="=myLocked=TRUE"
End If
End With
End Sub

Note just like the color fill macro in the last email, if you have
conditional formats set on this same range then this will remove them,
however, it will not effect the fill colors which you apply manually. This
is a toggle, so you just rerun it to remove the conditional formatting.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Tony" wrote:

Can you highlight locked cells in excell, so you can check you have locked
the right ones, and after checking turn the highlight off