Change Colour on a Cell after another cell has been changed

D

David Hardy

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.
 
A

Allllen

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
 
Top