Conditional formatting help

%3CLINGO-SUB%20id%3D%22lingo-sub-1991812%22%20slang%3D%22en-US%22%3EConditional%20formatting%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1991812%22%20slang%3D%22en-US%22%3EI%20am%20trying%20to%20create%20a%20conditional%20format%20that%20will%20highlight%20any%20value%20in%20a%20row%20that%20is%2020%25%20less%20than%20the%20first%20recorded%20value.%20Thank%20you%20in%20advance.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1991812%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-1992290%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1992290%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F903227%22%20target%3D%22_blank%22%3E%40Jwell1790%3C%2FA%3E%26nbsp%3BEasiest%20to%20demonstrate%20with%20some%20working%20examples.%20Please%20have%20a%20look%20at%20the%20attached%20file%20and%20see%20if%20it%20meets%20your%20requirement.%20In%20the%20first%20example%20(one%20row%201)%2C%20the%20CF%20rule%20assumes%20the%20first%20number%20is%20in%20A1%20and%20applies%20the%20formatting%20to%20the%20range%20A1%3AJ1.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20second%20example%20is%20a%20bit%20more%20complicated%20as%20it%20will%20look%20for%20the%20first%20non-blank%20cell%20with%20a%20number%20in%20the%20entire%20row%205%2C%20to%20determine%20where-ever%20the%20first%20recorded%20value%20is%20on%20that%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBoth%20CF%20rules%20will%20skip%20empty%20cells%20in%20the%20ranges%20to%20be%20formatted.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I am trying to create a conditional format that will highlight any value in a row that is 20% less than the first recorded value. Thank you in advance.
1 Reply

@Jwell1790 Easiest to demonstrate with some working examples. Please have a look at the attached file and see if it meets your requirement. In the first example (one row 1), the CF rule assumes the first number is in A1 and applies the formatting to the range A1:J1.

 

The second example is a bit more complicated as it will look for the first non-blank cell with a number in the entire row 5, to determine where-ever the first recorded value is on that row.

 

Both CF rules will skip empty cells in the ranges to be formatted.