Change Colour on a Cell after another cell has been changed
 

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

Change Colour on a Cell after another cell has been changed
 

Select the cell with the number in it
Choose Format Conditional Formatting
If your cell with the X in it is in cell B2, enter
Formula is =B2="X"
and set the formatting how you want it to be.

HTH
--
Allllen


"David Hardy" wrote:

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