I am trying to conditionally format a (fairly) large section using a formula. In the example below, I have rows that may or may not have a total number. If there is a number in the total column, I want the Item name to bold. I am trying to figure out an easier way to format without having to do each row individually. I have tried paint formatter but all of column 1 would bold when A2>0, not format to seperate rows.
Formual for conditional formatting:
If B2>0 then B1 bold
If C2>0 then C1 bold
Etc.
<tbody>
</tbody><colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;" span="6"></colgroup>
Formual for conditional formatting:
If B2>0 then B1 bold
If C2>0 then C1 bold
Etc.
1 | 2 | 3 | 4 | 5 | 6 | 7 | |
A | Item | Total | Mon | Tue | Wed | Thu | Fri |
B | Carrot | 15 | 5 | 5 | 5 | ||
C | Beans | ||||||
D | Onion | 4 | 2 | 2 | |||
E | Celery |
<tbody>
</tbody><colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;" span="6"></colgroup>