Thread: Compare values and average it

Hi,

I wanted to know how I can get, Cell 1 to add values form Cell 2+Cell 3 and the added value to be compared to Cell 4 (which has a value of 100) and if the combined value of Cell 2 and Cell 3 is 30 Cell 1 to be coloured red as its less than 50% of the value in Cell 4 (100).

not sure the above makes sense, hmmm let me know if further clarification is needed

CELL 1: total of Cell 2 and Cell 3 compared to Cell 4 and coloured according
CELL 4: comparison number (100)


Thanks

Hi Bavexcel,

If I'm understanding you correctly, in cell A1 you just need the formula:

=A2+A3

Then you want to apply conditional formatting to cell A1 such that if the value in A1 is less than half of the value in A4 it should be red. If it's greater than half it will be the default color for that cell. If that is correct, select cell A1 and click the Conditional Formatting button in the toolbar.

Next click "New Rule", then select "Use a formula to determine which cells to format". Below that, in the text box beneath "Format values where this formula is true", type:

=A1<A4*0.5

Click the Format.. button to set the font or background color of your choice and click OK a few times to return to your worksheet.

Hope that helps!