I am putting together a worksheet where students have to enter formula to
calculate a times table, at the moment it looks like this;

1 2 3 4 5
1
2
3
4
5
going all the way to 10 in columns and rows. To calculate the correct number,
they have to use a variety of mixed cell references. I want to be able to
enter conditional formatting to make each cell change to a different colour
if they use the exact formula, eg, = $A4*B$3, etc. So far I'm not having a
lot of success as the conditional formatting does not seem to take any
account of whether the $ sign is present or not. Can anyone please help,
thanks.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200612/1