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? |
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? |
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? |
add fill color or font color to if function
|
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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 09:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com