Formatting Cells - color based
 

I know this is "conditional" and I know that excel limits to 3 conditions -
but specific question...
Can you write a macro to include several conditions?

This is what I want...

E(8-300)should be green if there is data in Q(8-300)
red if blank
F(8-300)should be green if there is data in Q(8-300)
red if blank

Also - same concept - if data in C(8-300) turn Green
if data in B(8-300) turn yellow

So I am looking at 6 conditions - need to know if this is possible on any
level.

Thanks!!!

Hi, Angela. Try this:

http://vbaexpress.com/kb/getarticle.php?kb_id=90
************
Anne Troy
www.OfficeArticles.com

"AngelaG" wrote in message
...
I know this is "conditional" and I know that excel limits to 3 conditions -
but specific question...
Can you write a macro to include several conditions?

This is what I want...

E(8-300)should be green if there is data in Q(8-300)
red if blank
F(8-300)should be green if there is data in Q(8-300)
red if blank

Also - same concept - if data in C(8-300) turn Green
if data in B(8-300) turn yellow

So I am looking at 6 conditions - need to know if this is possible on any
level.

Thanks!!!

It sounds like you have 2 conditions for column E and 2 conditions for
column F, for which you can use conditional formatting.

What columns turn colours if there's data in columns C or B?
Even if you're still describing conditions for columns E and F, you
should still be able to do this with conditional formatting, assuming
you format the cells as red to begin with.


AngelaG wrote:
I know this is "conditional" and I know that excel limits to 3 conditions -
but specific question...
Can you write a macro to include several conditions?

This is what I want...

E(8-300)should be green if there is data in Q(8-300)
red if blank
F(8-300)should be green if there is data in Q(8-300)
red if blank

Also - same concept - if data in C(8-300) turn Green
if data in B(8-300) turn yellow

So I am looking at 6 conditions - need to know if this is possible on any
level.

Thanks!!!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html