| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lock range based on values loop
I have a range "rows F$12:F$60" and if F4 (which is the sum of the range) is = than the control "$C$4" then the cells format red and then I want that range to lock. This is repeated up to column CW i.e. for range G$12:G$60 if G$4 is =$C$4 the range is locked, etc, etc, Looking through some of the previous examples I imagine that I would have to set some sort of loop for each column that increments but I dont know how. I previously asked to try to get it to lock based on conditional formatting but the response was that this was not possible. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need sum of top values in a range based on criteria | Excel Worksheet Functions | |||
| Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
| Sum values in columns based on values in named range | Excel Worksheet Functions | |||
| Populating a cell based on a range of values | New Users to Excel | |||
| sum the values of a range based upon multiple ranges and criteria | Excel Worksheet Functions | |||
Threaded Mode
