Excel help (Conditional Formatting)

Was wondering if someone could give me a little help on using the conditional formatting in excel...

Basically I have a few cells highlighted based on data which looks similar to:

A B C D E F G H I

1 User Week 1 2 3 4 5 6 Total
2
3 John 0 1 0 1 2 1 5
4 Dave 0 0 0 0 0 0 0
5 Paul 0 1 0 0 1 0 2

the cells to be highlighted say will be the horizontal line for 4 ---- Dave, as the total = 0.
To highlight this usually in excel, I would use the conditional formatting in excel, however I was wondering if this could be changed so that the colour could be taken from a cell value, instead of going through the menus all the time?!

Not without using VBA

How would I go about doing this?

Quote:

---

Originally Posted by Workaholic

How would I go about doing this?

---

You will need to write a loop, using if statements to determine which rows should be highlighted.

If you don't know vba its very easy - I learned it using a combination of the help file, google and playing around recording macros.

There are many ways to write it, but I would do it using a while loop.

Sorry, can't really help you much more unless I do it for you...