Search results
-
M
Clear cell depending on data validation
Hi I have a cell which has a "Yes/No" drop down as an answer to a question. If this Cell (say B1) is set to "No", then conditional formating sets C1 to grey colour and if the cell is edited an error message (through a Custom Data Validation) returns an error message - to all intents the cell is...