Conditional formatting: If the total of two cells is lower then another cell

[IMP2023]

Hello,

I would be really grateful if someone could answer the following

If the TOTAL of two cells is less then the value you of another cell then post cells red, for example;

if A3+A4 is less than C5

turn cells red

thank you in advance

 

[Joe4]

Welcome to the Board!

Select the cell you want to format, go to Conditional Formatting, click "New Rule", select the "Use a formula to determine which cells to format" option and enter this formula:

=A3+A4<C5

Then choose your desired formatting options/color.