Conditional Formatting

[kgarland]

I'm doing a report in which I'd like to have the cell automatically bold the font and change the background for 7 people. Is there any way to increase the Conditional Formatting wizard box from 3 to as many as i want?

Or will I have to resort to another way of accomplishing my main goal?

 

[IML]

On 2002-08-22 14:25, kgarland wrote:
I'm doing a report in which I'd like to have the cell automatically bold the font and change the background for 7 people. Is there any way to increase the Conditional Formatting wizard box from 3 to as many as i want?

Or will I have to resort to another way of accomplishing my main goal?

If all people are to be formatted the same, you could list them on your sheet somewhere and name them, for example, "mypeople" via the name box. You could then use one formula such as
=COUNTIF(mypeople,B2)
in cell b2 for example.

 

[kgarland]

UNFORTUNEATELY, EACH PERSON WILL HAVE A DIFFERENT BACKGROUND COLOR. WOULD THAT FORMULA STILL APPLY?

 

[IML]

On 2002-08-22 14:36, kgarland wrote:
UNFORTUNEATELY, EACH PERSON WILL HAVE A DIFFERENT BACKGROUND COLOR. WOULD THAT FORMULA STILL APPLY?

No it would not. You would be limited to three using straight conditional formatting. Stay tuned for a vba solution, or better yet, take advantage of the search function here. This subject has been brought up many, many times.

Good luck.