Hello,
In my excel file, which is a template, my respondent has to make a choice between 3 options with a dropdown list. When he selects an element, it returns to cell D2 the element. For instance, if I select "Product Range" in the dropdown menu, it appears "Product Range" in D2.
But, depending on this data, I would like that conditional element appears/ disappear. If you select Cost Center --> Name is hidden, if you selected Product Range --> Code is hidden. (formula : =IF($D$2="Product Range";"Name";""). But I would like to remove the border from cell E5 (it looks like a text box). Indeed, if Name is empty, the text box should be hidden.
How can I add a conditional format to borders? Or maybe, there is a workaround?
Thank you for your help, and have a nice day!
Select the cell with the formula that returns Name.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=$D$2<>"Product Range"
Click Format...
Activate the Border tab.
Click the None button.
Click OK, then click OK again.
Do the same for the cell with the formula that returns Code, but with the formula
=$D$2<>"Cost Center"
A slight variant that I used to use, is to format the input boxes as if they were each in use, but then use the conditional format to reset the format to background if the string does not match the required value. My taste for colour has probably become more restrained over the years, but the image illustrates the type of effect one can achieve.
