Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ok i've looked all over but i am new to excel and don't know how to change
the advice people have given to others to suit my own purposes. So my question.. I am making a spreadsheet form that people are going to be filling out using both text and numbers. Most of the sheet will be unlock, but i want certain cells to be visible (but greyed out) when another cell has a certain value. for example this code would be in E5 -- =If(D5=15,2,"grey out E5") IE if D5=15 then the value in E5 would be 2, otherwise E5 would be greyed out and unaccesable. Is this even possible? thanks in advance. Athens |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable VBA code execution when loading a workbook | Excel Discussion (Misc queries) | |||
can you entre a bar code into a excel cell? | Excel Worksheet Functions | |||
Find the cell value in excel by using vb code | Excel Discussion (Misc queries) | |||
excel: How can I color code rows based on a value in a cell? | Excel Discussion (Misc queries) | |||
disable cell | Excel Discussion (Misc queries) |