| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking cell
Good afternoon, is there a formula or condition formatting available to lock
cells if the font colour is specified? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| locking only one cell | Excel Discussion (Misc queries) | |||
| locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
| Dynamically locking a cell depending upon value of another cell. | Excel Discussion (Misc queries) | |||
| Locking a cell | Excel Worksheet Functions | |||
| Cell locking trouble | Excel Discussion (Misc queries) | |||
Linear Mode
