Does anyone know a method to get a fill effect under conditional formatting
similar to the ability to use in a drawing object under format autoshape
colors and lines fill color fill effects? I would like to go from green
to yellow in a single cell under a condition. I believe the answer may be
"no", but thought I would ask.

Thanks,

Danny