| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change colour of data when changed | Excel Discussion (Misc queries) | |||
| Change cell Colour when a number of days have been passed | Excel Discussion (Misc queries) | |||
| get a cell to change colour from a value, eg 1to7=green etc | Excel Discussion (Misc queries) | |||
| Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
| Cell Change Color - Need Help | New Users to Excel | |||
Hybrid Mode
