A fellow employee has a worksheet with cells that are
color formatted based upon where the dates entered fall
into a specified date range. So if a date s in Range A
the cell turns yellow, etc... Now he wants to add
additional ranges, range C for example. If the date falls
under this criteria he wants the cell to be half yellow,
and the other half green, he wants 2 colors to appear. I
am unsure how to format a cell in this manner, is it even
possible?
I am looking for additional formatting patterns that allow
this, or macros, VBA, or programming. Your help would be
greatly appreciated.
Thanks, Rob