SOLVED

Formating cells under Header 2, Header 3, Header 4, etc, based on cells under Header 1, in the same

%3CLINGO-SUB%20id%3D%22lingo-sub-1195661%22%20slang%3D%22en-US%22%3EFormating%20cells%20under%20Header%202%2C%20Header%203%2C%20Header%204%2C%20etc%2C%20based%20on%20cells%20under%20Header%201%2C%20in%20the%20same%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1195661%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3CBR%20%2F%3EI%20try%20to%20format%20cells%20based%20on%20a%20minimum%20list%3A%3C%2FP%3E%3CTABLE%20width%3D%22387%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2278%22%3Eminimum%3C%2FTD%3E%3CTD%20width%3D%2275%22%3Ecount%201%3C%2FTD%3E%3CTD%20width%3D%2281%22%3Ecount%202%3C%2FTD%3E%3CTD%20width%3D%2278%22%3Ecount%203%3C%2FTD%3E%3CTD%20width%3D%2275%22%3Ecount%204%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E50%3C%2FTD%3E%3CTD%3E35%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E20%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E20%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E50%3C%2FTD%3E%3CTD%3E60%3C%2FTD%3E%3CTD%3E55%3C%2FTD%3E%3CTD%3E65%3C%2FTD%3E%3CTD%3E45%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E30%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3E45%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E35%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E50%3C%2FTD%3E%3CTD%3E20%3C%2FTD%3E%3CTD%3E40%3C%2FTD%3E%3CTD%3E60%3C%2FTD%3E%3CTD%3E50%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20number%20in%20one%20of%20the%20cells%20are%20lower%20then%20minimun%2C%20it%20should%20be%20formated%20to%20example%20red.%3C%2FP%3E%3CP%3EThis%20is%20a%20big%20document%2C%20and%20it%20will%20take%20forever%20to%20do%201by1.%20If%20there%20a%20way%20to%20do%20this%20faster%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThx%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1195661%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1203127%22%20slang%3D%22en-US%22%3ERe%3A%20Formating%20cells%20under%20Header%202%2C%20Header%203%2C%20Header%204%2C%20etc%2C%20based%20on%20cells%20under%20Header%201%2C%20in%20the%20s%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1203127%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F568569%22%20target%3D%22_blank%22%3E%40Chrir%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20the%20attach%20workbook%20solution%20file%20for%20you.%3C%2FP%3E%3COL%3E%3CLI%3ESelect%20the%20range.%20eg%3A%26nbsp%3BB2%3AE2%3C%2FLI%3E%3CLI%3EGo%20to%20%26gt%3B%20Conditional%20Formatting%20%26gt%3B%20New%20Rule%20%26gt%3B%20Select%20Use%20formula%20to%20determine%20which%20cell%20to%20format%3C%2FLI%3E%3CLI%3EPaste%20the%20below%20formula%26nbsp%3B%3C%2FLI%3E%3CLI%3ESelect%20your%20desired%20highlight%20color%20by%20select%20format.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DB2%3AE2%26lt%3B%24A2%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Snag_1665d0b0.png%22%20style%3D%22width%3A%20639px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F174327iFA12D76B991BFA1D%2Fimage-dimensions%2F639x272%3Fv%3D1.0%22%20width%3D%22639%22%20height%3D%22272%22%20title%3D%22Snag_1665d0b0.png%22%20alt%3D%22Snag_1665d0b0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EImportant%20%3A%20Make%20sure%20you%20select%20the%20correct%20range%20%26amp%3B%20ensure%20that%20your%20minimum%20value%20is%20absolute%20column%20%24A2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%20%7C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excelexciting.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.ExcelExciting.com%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1213030%22%20slang%3D%22en-US%22%3ERe%3A%20Formating%20cells%20under%20Header%202%2C%20Header%203%2C%20Header%204%2C%20etc%2C%20based%20on%20cells%20under%20Header%201%2C%20in%20the%20s%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1213030%22%20slang%3D%22en-US%22%3EThank%20you!!%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi!
I try to format cells based on a minimum list:

minimumcount 1count 2count 3count 4
10550350
202520525
5060556545
3015452535
5020406050

 

If the number in one of the cells are lower then minimun, it should be formated to example red.

This is a big document, and it will take forever to do 1by1. If there a way to do this faster?

 

Thx

2 Replies
Highlighted
Best Response confirmed by Chrir (New Contributor)
Solution

Hi @Chrir 

 

Please see the attach workbook solution file for you.

  1. Select the range. eg: B2:E2
  2. Go to > Conditional Formatting > New Rule > Select Use formula to determine which cell to format
  3. Paste the below formula 
  4. Select your desired highlight color by select format.

 

 

=B2:E2<$A2

 

 

Snag_1665d0b0.png

 

Important : Make sure you select the correct range & ensure that your minimum value is absolute column $A2

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com

If you find the above solution resolved your query don't forget mark as Official Answer.

 

Highlighted