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"
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.
