View Single Post
  #1   Report Post  
AngelaG
 
Posts: n/a
Default 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!!!