Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add fill color or font color to if function
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill color and font color icons do not work in excel | Excel Discussion (Misc queries) | |||
trouble with viewing fill color and font color | Excel Worksheet Functions | |||
Fill color doesn't work although font color does. | Excel Worksheet Functions | |||
Sort or sub-total by Fill color or font color | Excel Discussion (Misc queries) | |||
My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) |