Formatting Cells - color based

[Guest]

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]

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.