Conditional Formatting in an Excel table

[John_Wick]

Dear,

I have an Excel table that contains data for Calories, Carbs, Protein, and Fat.

I would like to apply a Conditional Formatting to the Calories column that would make it red and bold when the formula [(Carbs x 4) + (Protein x 4) + (Fat x 9)] result is different than the value in Calories column (see pic attached).

Do I need to create a conditional formatting rule for EVERY row? What about the new rows when created?

Thanks for the help,

JW

model.png

[63falcondude]

Hello and welcome to the forum. You only need to create one Conditional Formatting formula. You just have to apply it correctly.

Click on the top of the "CALORIES" cell to highlight the entire table column > Conditional Formatting > New Rule > Use a formula

=C2<>SUM(D2*4,E2*4,F2*9)

Change font color to red and font style to bold.

Note that this formula assumes that the table starts in A1.

[6StringJazzer]

What about the new rows when created?

If this is a true Excel Table, then the same formatting (conditional formatting plus all other formatting) will automatically be applied to new rows added to the table.

[John_Wick]

Thanks! It is working perfectly!