I have color filled cells conditional formatted to change fill to white when the cell = X. When I type an X it does change to white fill, but when I delete the X it stays white until I scroll the cell off the screen and back again. Then the color fill has returned. I checked Options\Formulas and Automatic Calculation is selected.
Any ideas?
Any ideas?