: I wonder if there is a better way to do it, such as to highlight  the
: entire  row-C and just specify conditional  formatting once as

Highlight the column, row  or range you want to format.

Select "Conditional Formatting" from the "Format" menu.

Select "Formula Is" from the dropdown menu.

Enter "=if(B1>100,1,0)" (no quotes) as the formula.

Enter the format.

Excel will increment b1 to b2 to b3 etc. until the end of the
column. You can double check this by going to another cell  and
opening the Conditional formatting  dialog box.


While there is nothing wrong with your formula, you only need
the condition ("=B1>100") for conditional formatting.