if statement and cell formatting

[malpropio]

Hi everyone
Here is what I'm trying to do,
I have that spreadsheet and I need to make a if statement for a cell
that will compare 2 other cell and change the background color to
yellow whenever cell1 > 0.8*cell2.

thx for your help

malpropio.

 

[meatshield]

You'll have to use conditional formatting. Assuming that cell 1 is A1,
Cell 2 is A2, and the cell with the formatting is A3. Select cell A3
and then go to Format->Conditional Formatting and pick 'Formula Is"
and type the formula:
=A1>0.8*A2
The click the Format button, got to patterns and pick the color you
want the cell to be.