Conditional Formatting Based on Adjacent Cells and Values

Hey All,

I'm trying to create conditional formatting that basically lets the user know which cells need to be filled in. There's a serial number that's filled in a cell that has 3 digits, one for each line up, where each digit represents the quantity of parts in each line up. So, I may have a serial no that says "431". What I'd like to do is have the first 4 cells in the first column turn orange (A1:A4), the second column is based on the second digit (3), so 3 cells would turn orange in the second column (B5:B7), and the last digit is a 1, so the third column would fill in C8 orange. If it isn't orange, it's striped.

Tough to explain, easy with an example. Please see attachment.

I just can't figure it out, maybe the gurus here have some slick ideas. Thanks for any help

The table on the left (Column BCD) is the table I'm trying to get working. The table on the right (Column FGH) is an example of how it should look using the sample model number. Alas, I have not been able to get either solution to work yet... but I'm still trying

Okay, with the help of you all, I think I've got it (written as a formula, not conditional formatting):

Please Login or Register  to view this content.

Couldn't have done it without you

Didn't think about the fact that I was using the SUM function in my formulas, so it messed up when I applied it to the conditional formatting. Below is the correct code.

Note to self: Make sure everything you type is awesome before hitting "Post".

Please Login or Register  to view this content.

Thanks again all - you've been a great help