Change the cell fill color

**phoenix4031** · 08-11-2009, 11:52 AM

What is the structure an =if formula which will change the cell fill color?

**NBVC** · 08-11-2009, 12:03 PM

You need Conditional Formatting found in the Format Menu...

If you are more specific, then we may be able to help you set it up.

**Palmetto** · 08-11-2009, 12:14 PM

What is the structure an =if formula which will change the cell fill color?

Excel Help is your friend.

See the Help on the IF function for structure.

As NBVC pointed out, you need to use Conditional Formatting. That being said, ALL formulas used in CF must evaluate to TRUE or FALSE

e.g.
SUM(A1 + B1) = 3 is TRUE if A1= 1 and B1 = 2
SUM(A1 + B1) = 4 is FALSE if same values are used

You may also want to read about comparison operators because they must be used with the IF function when using it in a CF formula.

**phoenix4031** · 08-11-2009, 12:21 PM

OK!
Currency values: cell A2 and B2 will be a manual entries. A table is filled based on on a formula
=(A2 * A5) + 7.
A2 is the constant in all cells throughout the table. A5 increases. B2 containes a value. If the cell content is less than the value in B2, then the cell fill color needs to change
I think it may look something like this: =(A2*A5)+7, =IF(____<B2,______).
I dont know what goes in the blanks.........