add fill color or font color to if function

[MEDaniel]

I am trying to write a formula so that if E17<G16andE17<H16, red cell fill or
red font. Any idea how to do this?

 

[Nattasiray]

You should using Conditional Formatting

Suppose cell that you check is I17
Select Cell I17
click format -> Conditional formatting
set condition to Formula is
enter =and(E17<G16, E17<H16)=true at the text box
click format the set font color and cell fill
click ok button at each dialog

 

[MEDaniel]

Added conditional formatting. Typed number into cell. no color change. ????

 

[Nattasiray]

Please send file to me at (e-mail address removed). I will figure out.

 

[John C]

The =TRUE is unnecessary. As long as all cells E17, G16, H16 have numbers
(and not text that looks like numbers), then this should work:
=AND(E17<G16,E17<H16)

 

[ShaneDevenshire]

Hi,

you can use a rather shorter formula as described below:

2003:
1. Select your range
2. Choose Format, Conditional Formatting
3. From the first dropdown pick Formula is
4. In the next box enter your formula:
=AND(E17<G16:H16)
5. Click the Format button and on the Patterns tab, pick a color
6. Click OK twice.


2007:
1. Select your range
2. Choose Home, Conditional Formatting, New Rule
3. Pick Use a formula to determine which cells to format
4. In the Format values where this formula is true, enter the formula:
=AND(E17<G16:H16)
5. Click the Format button and on the Fill tab choose a color
6. Click OK twice.

 

[MEDaniel]

Thanks ShaneDevenshire. That did the trick!

Hi,

you can use a rather shorter formula as described below:

2003:
1. Select your range
2. Choose Format, Conditional Formatting
3. From the first dropdown pick Formula is
4. In the next box enter your formula:
=AND(E17<G16:H16)
5. Click the Format button and on the Patterns tab, pick a color
6. Click OK twice.


2007:
1. Select your range
2. Choose Home, Conditional Formatting, New Rule
3. Pick Use a formula to determine which cells to format
4. In the Format values where this formula is true, enter the formula:
=AND(E17<G16:H16)
5. Click the Format button and on the Fill tab choose a color
6. Click OK twice.

 

[ShaneDevenshire]

Thanks for the feedback!