1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How can I stop editing the data but can change the interior color

Discussion in 'Ask an Excel Question' started by uday, May 16, 2018.

  1. uday

    uday Member

    Messages:
    164
    Hi,

    Is there any possibility to change the cell color keeping the cell data protected mode?

    I need to change the cell color only not the cell's data.

    Regards,
    Roy
  2. vletm

    vletm Excel Ninja

    Messages:
    4,163
    uday
    Yes .. eg with Conditional Format.
    What would 'trigger' the cell color change?
  3. uday

    uday Member

    Messages:
    164
    Color can be anything. Please note that I dont want to let others to edit cell's data. However I can change the cell color.
  4. vletm

    vletm Excel Ninja

    Messages:
    4,163
    uday ...hmm?
    1st sentence:
    Color cannot be anything! ... it should change ... as You wrote or how?
    2nd sentence: What would be connection of this case?
    3rd sentence: As I wrote in #2 Reply.
    Any answers, any sample sheet ...
  5. uday

    uday Member

    Messages:
    164
    The reason why I am saying that color can be anything is - its depends on user requirement to relate the legends type to its unique color type. In nutshell- if the data is recognized with high priority then it should be red or can be change to any other color depends on its own needs.

    User should not change the data. This is the main priority.

    Now, coming to your #2 Reply - I am not trying to change the cell color according to data. I dont want to imply Conditional logic here.

    I, simply want to protect cell data only, keeping the other options open.

    Regards,
    Roy

    Attached Files:

  6. vletm

    vletm Excel Ninja

    Messages:
    4,163
    uday
    Yes - file with one row.
    You would fill there much more data to show Your nutshell:
    In nutshell- if the data is recognized with high priority then it should be red or can be change to any other color depends on its own needs.
    ... or test this possible.

    Attached Files:

  7. uday

    uday Member

    Messages:
    164
    This is not what I wanted to achieve....Thanks for your effort..

    Want to lock the cell data only not conditional formating based on data type.

Share This Page