I'm trying to generate a color-background format result in one cell (cell B1
for instance) when a condition in another cell (A1) is met. I've tried
conditional formatting but it seems to apply only to conditions being met the
same cell that is affected.