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