Hi
I've set up formatting so that when I type R in column C, the sum in column B turns blue. Suddenly, the sums in column B are turning blue when I type them in and not when I type R in C.
The formula I'm using is:
'New Rule' then 'Use a formula to determine which cells to format'. I'm entering:
=C2="R" and choosing blue font.
It used to work but now this is happening. Does anyone know what I've done wrong?