Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex Conditional Sum | Excel Worksheet Functions | |||
Complex conditional formatting | Excel Worksheet Functions | |||
Complex Conditional | Excel Worksheet Functions | |||
Complex conditional formatting | Excel Worksheet Functions | |||
complex?? Q about Conditional formatting | Excel Worksheet Functions |