Forum Discussion
Solved
Formating cells under Header 2, Header 3, Header 4, etc, based on cells under Header 1, in the same
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 ...
Hi Chrir
Please see the attach workbook solution file for you.
- Select the range. eg: B2:E2
- Go to > Conditional Formatting > New Rule > Select Use formula to determine which cell to format
- Paste the below formula
- Select your desired highlight color by select format.
=B2:E2<$A2Important : 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
Hi Chrir
Please see the attach workbook solution file for you.
- Select the range. eg: B2:E2
- Go to > Conditional Formatting > New Rule > Select Use formula to determine which cell to format
- Paste the below formula
- 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
Thank you!!