| Home |
| Search |
| Today's Posts |
|
#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? |
| 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) | |||
Threaded Mode
