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