+ Reply to Thread
Results 1 to 6 of 6

I cannot choose Conditional Formatting

  1. #1
    Shawna
    Guest

    I cannot choose Conditional Formatting

    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. #2
    Registered User
    Join Date
    10-07-2003
    Location
    North Florida
    Posts
    6

    is sheet protected

    could be as simple as the sheet being protected.
    if so unprotect sheet and try again
    Hope this helps FD
    FD

  3. #3
    Randy
    Guest

    I cannot choose Conditional Formatting

    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. #4
    Kassie
    Guest

    RE: I cannot choose Conditional Formatting

    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. #5
    Shawna
    Guest

    RE: I cannot choose Conditional Formatting

    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.
    > > >.
    > > >

    > >


  6. #6
    Kassie
    Guest

    RE: I cannot choose Conditional Formatting

    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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1