How can i do this???

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
 
T

T. Valko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formatting colour in cells when one cell contains a character 1
Cumulative formula for word table 0
How to paste this down? 3
How can i put text in a cell depending on colour 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
How do I set focus (and select text) on a text box on a modeless userform? 0
VBA word change keys 0
I have lost 6 months work, how can i get my file back 1

Top