Forum Discussion
Solved
If a cell contain a specific text then remove text border
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,...
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"
The rules that I proposed will remove the borders if the user selects ANY other item than the intended one.
Ok it's noted, thank you.