add fill color or font color to if function
Thanks ShaneDevenshire. That did the trick!
"ShaneDevenshire" wrote:
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.
--
Thanks,
Shane Devenshire
"MEDaniel" wrote:
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?
|