Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. . |
#3
![]() |
|||
|
|||
![]()
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. . |
#4
![]() |
|||
|
|||
![]()
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. . |
#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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |