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 | 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
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<$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
- Thank you!!
