View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default add fill color or font color to if function

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?