| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
My pleasure. Thanks for the feedback
"Shawna" wrote: Thank you. This was the problem. I had 'track changes' on which made it a shared file. I had to turn track changes off to do conditional formatting and to also merge cells. I had not realized it would lock out certain things. Thanks for your help. "Kassie" wrote: Or else the file is shared, in which case you also cannot use conditional formatting. If true, you will have to remove the sharing, before using it. "Randy" wrote: It sounds like the sheet is protected. Unprotecting the sheet should enable the Conditional Formatting. -----Original Message----- I have used conditional formatting on some spreadsheets, so I know how to use it. My problem is that on other spreadsheets I cannot choose it from the Format Menu. The Conditional Formatting choice is lightly shaded. Why is this and how can I fix it. . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
