Home

Conditional Formatting duplicating rules

%3CLINGO-SUB%20id%3D%22lingo-sub-327733%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20duplicating%20rules%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327733%22%20slang%3D%22en-US%22%3E%3CP%3EIm%20trying%20to%20create%20an%20inventory%20and%20each%20item%20has%20a%20different%20required%20quantity.%20I%20want%20the%20row%20of%20that%20item%20to%20highlight%20one%20of%20three%20colors%20based%20off%20of%20the%20actual%20stocked%20quantity%20of%20that%20item.%20i%20was%20able%20to%20create%20the%20three%20rules%20i%20wanted%2C%20but%20am%20not%20able%20to%20copy%20and%20paste%20the%20condition%20to%20the%20next%20row.%20it%20just%20carries%20the%20rules%20for%20the%20first%20row%20so%20that%20only%20row%202%20will%20change%20all%20rows%20in%20worksheet...%3C%2FP%3E%3CP%3Eattached%20is%20a%20screen%20shot%20of%20the%20worksheet%20and%20rules%20i%20have%20a%20created..%20thanks%20so%20much%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71392i66DBCE30693BC84E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202019-01-29%20at%2011.37.33%20PM.png%22%20title%3D%22Screen%20Shot%202019-01-29%20at%2011.37.33%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-327733%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327813%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20duplicating%20rules%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327813%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20don't%20need%20to%20duplicate%20your%20rules%20if%20you%20use%20relative%20references%20(%3D%24E2%3D%24D2)%20and%20apply%20your%20rule%20to%20entire%20range%20(e.g.%20%24A%242%3A%24J%24200)%3C%2FP%3E%3C%2FLINGO-BODY%3E
cybrnitro
New Contributor

Im trying to create an inventory and each item has a different required quantity. I want the row of that item to highlight one of three colors based off of the actual stocked quantity of that item. i was able to create the three rules i wanted, but am not able to copy and paste the condition to the next row. it just carries the rules for the first row so that only row 2 will change all rows in worksheet...

attached is a screen shot of the worksheet and rules i have a created.. thanks so muchScreen Shot 2019-01-29 at 11.37.33 PM.png

1 Reply

You don't need to duplicate your rules if you use relative references (=$E2=$D2) and apply your rule to entire range (e.g. $A$2:$J$200)