| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell colour changes, locked cells.
I recently asked how to change a cell colour when my stock level fell below a
min stock value. This has been very helpfully answered. Thank you all. But , if I use the "Formula Is:= and click on the cell it enters as $A$1 which means the cell is locked. But, when I add or delete stock lines (rows) understandably the cell reference won't change. Is there a way to stop the cell entering as $A$1 and instead enters as simply A1? Thank you CD01 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell colour changes, locked cells.
I have the same problem sometimes. My work around is to go back into the
conditinal equatin and remove the $s "CD01" wrote: I recently asked how to change a cell colour when my stock level fell below a min stock value. This has been very helpfully answered. Thank you all. But , if I use the "Formula Is:= and click on the cell it enters as $A$1 which means the cell is locked. But, when I add or delete stock lines (rows) understandably the cell reference won't change. Is there a way to stop the cell entering as $A$1 and instead enters as simply A1? Thank you CD01 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| Changing cell colour depending on another cells value... | Excel Discussion (Misc queries) | |||
| Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
| How do I set a colour to 4 cells based on the value of a cell | Excel Discussion (Misc queries) | |||
Linear Mode
