# Need Help to Create Excel Sheet Checklist !!!

1. ## Need Help to Create Excel Sheet Checklist !!!

Hello,
I need to create an excel checklist,
So that, if first check (cell) is not ticked then all other checks (cells) will be grayed out and locked,
If first check (cell) is ticked, second check (cell) will be unlocked and color will become normal,
if second cell is ticked, third will unlocked and so on.

here I'm attaching my excel sheet, you will understand what kind of checks and conditions I want.

2. ## Re: Need Help to Create Excel Sheet Checklist !!!

Try something like:
``Please Login or Register  to view this content.``
You can use conditional formatting to "grey out" the rows that are not yet ticked. See attachment for a worked example.

3. ## Re: Need Help to Create Excel Sheet Checklist !!!

I was thinking like this

``Please Login or Register  to view this content.``
Kind regards
Leo

4. ## Re: Need Help to Create Excel Sheet Checklist !!!

Thanks guys, let me check.

5. ## Re: Need Help to Create Excel Sheet Checklist !!!

Originally Posted by LeoTaxi
I was thinking like this

``Please Login or Register  to view this content.``
Kind regards
Leo

You are amazing bro, this is what I need.
One more thing I wanna ask, Is there any way to change 1, 0 and -1 to Yes, NA and No respectively.
And, Is there any good study materials available for vb/vba. I'm beginner.

6. ## Re: Need Help to Create Excel Sheet Checklist !!!

This for Yes No NA

``Please Login or Register  to view this content.``
for the studie material, I used and use google and a lot of practise

Kind regards
Leo

7. ## Re: Need Help to Create Excel Sheet Checklist !!!

Originally Posted by LeoTaxi
This for Yes No NA

``Please Login or Register  to view this content.``
for the studie material, I used and use google and a lot of practise

Kind regards
Leo

Thanks again brother,
But after this code, tick is no longer there. It simply put text Yes/NA/No.
Check my excel sheet.

And is there any way to assign different colors to Yes, NA and No Rows.

Regards
Sagar

8. ## Re: Need Help to Create Excel Sheet Checklist !!!

In this i removed the data validation, there is a userform comming for that,
but see

``Please Login or Register  to view this content.``

9. ## Re: Need Help to Create Excel Sheet Checklist !!!

Originally Posted by LeoTaxi
In this i removed the data validation, there is a userform comming for that,
but see

``Please Login or Register  to view this content.``

Thanks again brother, you are great.

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