• 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


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

Conditional formatting


Dear All,

I want a conditional formatting for all rows uder following condition.
Col H has value yes or no.
if i change the value in col H yes then entire row from A:H filled with color .
If the value is no then entire row remain same.
2. if i select col H value yes then entire row become locked automaticaly and if changes require it ask for password.
if col H value is no then it remain same.

Thanks ...