View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
meatshield meatshield is offline
external usenet poster
 
Posts: 39
Default if statement and cell formatting

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:
=A10.8*A2
The click the Format button, got to patterns and pick the color you
want the cell to be.

On Mar 13, 1:17 pm, "malpropio" wrote:
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.