Complex Conditional Formatting

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

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
 
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
 
Back
Top