How can i do this???

  • Thread starter Thread starter wilko
  • Start date Start date
W

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
 
Try this...

To color B1:D1 when A1 has an entry...

Select the *entire* range B1:D1 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
 
Back
Top