Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to lock cell color, but allow text - how do I do this?
One row is blue
Next row is white Third row is blue etc... How do I keep this format, but allow text to be written in these cells? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to lock cell color, but allow text - how do I do this?
Use conditional formatting to color your rows. See
www.cpearson.com/excel/banding.htm for examples. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "cgotzeff" wrote in message ... One row is blue Next row is white Third row is blue etc... How do I keep this format, but allow text to be written in these cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock text box to cell | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
Cell Capacity - text | Excel Discussion (Misc queries) | |||
How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) |