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!!!