Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Formatting Conditional On Other Cells Fill Color?
I'm not sure of the best way to go about this. First let me say that I
am a basic though long time Excel user. I can use basic Excel functionality but I wouldn't even know where (much less how) to begin to write VB code without very detailed instructions. I am trying to create conditional formatting based on a gantt type chart. This chart may not line up correctly using variable width fonts but consider the following; ABCDEF 1 GORO 2 BBB 3 BBB 4 BB There are no cell values, just cell formatting. The cell values in the above example represent color filled cells. (B=BLACK, W=WHITE, G=GREEN, O=ORANGE, R=RED) In row #1 I want to color each cell based on the number of color filled cells found in the column below it. So A1 would be white because there are no colored cells in column A. B1 would be green because there is 1 black cell in the column. C1 would be orange because there are 2 black filled cells under it and D1 would be red because there are 3 colored cells under it. I want to be able to highlight cells in a given row and select a black color fill and have row #1 automatically update itself based on the new total number of colored cells below it. I am very comfortable following very detailed instructions but sparse references will quickly get me lost. Thank you in advance! Roger Westbrook |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Formatting Conditional On Other Cells Fill Color?
whilst it is possible to colour a cell - short of vb - it's not possible to
detect what colour a cell is wrote in message oups.com... I'm not sure of the best way to go about this. First let me say that I am a basic though long time Excel user. I can use basic Excel functionality but I wouldn't even know where (much less how) to begin to write VB code without very detailed instructions. I am trying to create conditional formatting based on a gantt type chart. This chart may not line up correctly using variable width fonts but consider the following; ABCDEF 1 GORO 2 BBB 3 BBB 4 BB There are no cell values, just cell formatting. The cell values in the above example represent color filled cells. (B=BLACK, W=WHITE, G=GREEN, O=ORANGE, R=RED) In row #1 I want to color each cell based on the number of color filled cells found in the column below it. So A1 would be white because there are no colored cells in column A. B1 would be green because there is 1 black cell in the column. C1 would be orange because there are 2 black filled cells under it and D1 would be red because there are 3 colored cells under it. I want to be able to highlight cells in a given row and select a black color fill and have row #1 automatically update itself based on the new total number of colored cells below it. I am very comfortable following very detailed instructions but sparse references will quickly get me lost. Thank you in advance! Roger Westbrook |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting to Test Value in Cell | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Formatting cells Auto fill color using €śIf€ť | Excel Worksheet Functions | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) |