Applying calculated borders, background colours etc via "Custom Format Cell"
I'm having an issue with formatting on a straight table.
I'm trying to apply a border to the top of a cell which is denoted as a subtotal. I have created a dimension which displays a value "c" for these subtotal calculations (which will be removed for the final display, obviously):
For the values in bold, I wish to have a top border, effectively creating a line separating these cells as a top border.
To do this I have right clicked and selected "Custom format cell". In here I have clicked on the colour of the "border before cell" field and applied the calculation: =if([Exec P&L Calculation]='c',RGB(0,0,0),(RGB(220,200,220))):
However, this results in ALL cells having a top border applied, making every cell border appear, despite the dimension clearly showing "c" on the appropriate lines:
I've tried this with text and background colour with the same results.