I am using a spreadsheet as a checklist for collectables, and have a row of
numbers with a row of boxes underneath. When I have a number, I place an 'X'
in the cell below the number. Using conditional formatting, I get this cell
to change colour, but I would also like the cell with the number in to change
as well. Several tries using Conditional formatting have not succeeded.
--
Many thanks.

David