If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




add fill color or font color to if function
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? 
Ads 
#2




add fill color or font color to if function
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" 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? 
#3




add fill color or font color to if function
Added conditional formatting. Typed number into cell. no color change. ????
"Nattasiray" wrote: > 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" 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? 
#4




add fill color or font color to if function

#5




add fill color or font color to if function
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)  ** John C ** "MEDaniel" wrote: > Added conditional formatting. Typed number into cell. no color change. ???? > > "Nattasiray" wrote: > > > 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" 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? 
#6




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? 
#7




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? 
#8




add fill color or font color to if function
Thanks for the feedback!
 Thanks, Shane Devenshire "MEDaniel" wrote: > 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? 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
fill color and font color icons do not work in excel  huer59  Excel Discussion (Misc queries)  0  November 29th 07 01:06 PM 
trouble with viewing fill color and font color  CMinard  Excel Worksheet Functions  3  May 12th 06 09:09 PM 
Fill color doesn't work although font color does.  Marco  Excel Worksheet Functions  1  May 8th 06 12:44 AM 
Sort or subtotal by Fill color or font color  Excel_seek_help  Excel Discussion (Misc queries)  1  April 27th 06 09:01 PM 
My fill color and font color do not work in Excel Std Edition 2003  chapstick  Excel Discussion (Misc queries)  1  September 11th 05 08:48 PM 