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
Bookmarks