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