You can use Conditional Formatting to set the cell font or fill color.
Use the Formula option and this formula: =A1="Yes"
To lock the cell, use Data Validation, custom option and this formula:
=A1<>"Yes"
You can use Conditional Formatting to set the cell font or fill color.
Use the Formula option and this formula: =A1="Yes"
To lock the cell, use Data Validation, custom option and this formula:
=A1<>"Yes"
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks