Forum Discussion
If a cell contain a specific text then remove text border
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"
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"
Thank you very much for your answer! But, if there are more than 2 elements how can I put more options? For instance, if we have chosen "Partner entity" or "Cost center" I would like to remove it. Is there any "or" function?
I am going to use it, it's working well. 🙂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.
