I want to compare actual values with planned using a simple cell rules.
e.g If actual cell value = planned cell value go green and if not red.

This works fine for one cell but when I use paste special (format) for the
rest of the range the refernce is always the 1st planned value. I can't seem
to get rid of the $c$4 format and make it c4 because whenever I delete the $
symbol, excel puts it back.

Surely I don't have to do each cell one at a time?!