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

[Chrir]

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

minimum	count 1	count 2	count 3	count 4
10	5	50	35	0
20	25	20	5	25
50	60	55	65	45
30	15	45	25	35
50	20	40	60	50

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 · Accepted 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

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.

[#3 · Accepted solution]

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

[#4]

Thank you!!