I have a 4 page Excel form and let’s say if sections D10=Yes, F7=Yes, and F9=Yes on sheet 1, then on sheet3 sections A17 thru A36 and sections B17 thru B36 should be grayed out are locked. How is this written
I have a 4 page Excel form and let’s say if sections D10=Yes, F7=Yes, and F9=Yes on sheet 1, then on sheet3 sections A17 thru A36 and sections B17 thru B36 should be grayed out are locked. How is this written
This could be done with Conditional Formatting.
However conditonal formating can not reference cells in an other worksheet.
To work around this you could have cells on the worksheet which reference the cells on the other worksheet.
These cells can then be used in the conditional formatting.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
CF can reference cells on other sheets in XL2010 and beyond.
See http://www.techrepublic.com/blog/mic...th-references/
You're absolute right, PLM.
Guess XL2003 is still haunting me
Thanks, I was thinking more of a (If, Then) statement. For example +IF(OR(A1="Yes",B1="Yes",C1+"Yes"),"",Then [something that will lock the cells from entries and gray it out]
How can I get that from using conditional text, I dont know how to do that. Can you give me more direction? Thanks
It would probably be easier to offer suggestions if you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
If you need to lock teh cell, you will probably need to use data validation, as well
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Cant see away to attach a file here. I am coded a Excel form in Conditional Text, it contains several pages (5) total. I have (3) three selection boxes on Page 1. selection options are "Please select", "Yes", and "No". If Yes is selected in all three boxes, then I want to gray-out a section on Page 3.
My problem I can create condition to gray out the section if "Yes" is selected, but I cant get it to [ul]only[/ul] gray out when "Yes" is selected in all three boxes . My rule description is:Format selection areaPlease Login or Register to view this content.
. The code is repeated twice for the three boxes affacting the same selected area.Please Login or Register to view this content.
How do I get if to gray-out based on all three box conditions and not just one.
I got it to work, thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks