Complex Conditional Formatting
 

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

Complex Conditional Formatting
 

To the best of my knowledge, you can't format half a cell.

--
Regards,
Tom Ogilvy


"Rob" wrote in message
...
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

Complex Conditional Formatting
 

You can have multiple font styles in a single cell : just edit your cell,
select a fraction of the content and change the formatting. This only works
with labels, not if the cell contains a number for instance.
Then you can add a conditional formatting on top of it and, it the condition
matches, only the first fraction of text will change his formatting.

Hpe this helps

"Rob" wrote in message
...
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