How can i do this???

[wilko]

Can anybody help?

If I insert a tick or a certain symbol in one cell, how can I get other
cells on the same line to change colour, i.e to show that they have been
checked or viewed

Your help would be appreciated

JW

 

[T. Valko]

Try this...

To color B11 when A1 has an entry...

Select the *entire* range B11 starting from cell B1. Cell B1 will be the
active cell. The active cell is the one cell in the selected range that is
not shaded. The formula will be relative to the active cell.

Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=$A1<>""
Click the Format button
Select the desired style(s)
OK out