Handling borders in Conditional Formatting

[sparky2205]

Hi folks,
my query is in relation to what I call the "fuzzy" border when using conditional formatting.

The image above is what you get if you create a CF rule on a brand new spreadsheet. The cell this applies to has no borders applied.
If I click on the "fuzzy" border to the left it applies whatever border style is currently selected.
If I click on the applied border it removes the applied border and leaves it blank i.e. no border. It does not restore the "fuzzy" border.
My assumption is that this "fuzzy" border represents whatever border is currently on the target cell.
This is very useful. If I want to put a blue border on all sides of a cell except the left side I would use:

This will put the blue border on the three sides I want while leaving the left border unaffected.
If I accidentally click on the left border it will add the blue border, which I don't want. If I click on it again it will remove the left border completely, which I also don't want.
Currently when this happens the only way I can reinstate that "fuzzy" border is to delete that rule and start again.

My questions:
Is my understanding of what this "fuzzy" border represents actually correct?
Is there any way of reinstating the "fuzzy" border in an existing CF rule if I accidentally remove it?

 

[6StringJazzer]

Your interpretation of the fuzzy border is correct. When formatting borders in the worksheet (not in a CF rule), the fuzzy border means "not all cells in the current selection have the same border style on this side." When all selected cells do have the same border style, then it shows that style. In a worksheet, if you replace the fuzzy border by accident the only way to restore it is to cancel the change.

In a CF rule, the borders are always fuzzy to start with. If you are building a CF rule and accidentally replace the fuzzy border, there is no way to make it fuzzy again except with the Clear button and start your borders all over. If you save the rule, then the only thing you can do it Undo or delete the rule, and then build the rule again.

 

[sparky2205]

Thanks 6StringJazzer,
not the answer I was hoping for but the one I was expecting.
Have a good weekend.

 

[6StringJazzer]

Sorry to bear bad news. Have a good weekend!