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?!
Re: Excel help (Conditional Formatting)
Re: Excel help (Conditional Formatting)
How would I go about doing this?
Re: Excel help (Conditional Formatting)
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...