Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In spite of someones efforts to help me, I am not able to modify or ?? the
following to work on locked cells (only) in the selected range in column C. It is critical to the application. Will someone please help? Dim ws As Worksheet Set ws = Worksheets("Pricing") Dim ILastRow As Long ILastRow = ws.Range("B:B").SpecialCells(xlCellTypeLastCell).R ow With ws.Range("C6:C" & ILastRow) .Select .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Formula1:="=($B6=""*"")" .FormatConditions(1).Interior.ColorIndex = 4 End With ws.Range("C6").Select |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
How do U Color shade Locked and FormulaHidden Cells | Excel Programming | |||
change fill color of a range of cells based on color of a cell? | Excel Programming | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
I want the macros to be locked up when cells are locked up. | Excel Programming |