| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting a whole column but with the conditions < &
I am trying to get cells D2 thro' D71 to turn red if D65 cell formula is
63.0 and to turn yellow if D65 formula is <57.0 Formula in D65 is =D9/D10*D11*50 I have the following conditional formulas set up Formula is =D$65"63.0" Formula is =D$65<"57.0" But it will only turn yellow & seems to do this as soon as I enter data is cell D9 Please help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting a whole column but with the conditions < &
By putting your comparison values in quotes you are comparing with text
strings. If you want to compare with numbers, throw away the quote marks. -- David Biddulph "Carolyn" wrote in message ... I am trying to get cells D2 thro' D71 to turn red if D65 cell formula is 63.0 and to turn yellow if D65 formula is <57.0 Formula in D65 is =D9/D10*D11*50 I have the following conditional formulas set up Formula is =D$65"63.0" Formula is =D$65<"57.0" But it will only turn yellow & seems to do this as soon as I enter data is cell D9 Please help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting a whole column but with the conditions < &
Formula is =D$65"63.0"
Formula is =D$65<"57.0" Remove the quotes: =D$6563 =D$65<57 The second formula can be made more robust so that an empty cell won't be formatted (if D65 might ever be empty): =AND(COUNT(D$65),D$65<57) An empty cell will evaluate to 0 and 0 < 57. -- Biff Microsoft Excel MVP "Carolyn" wrote in message ... I am trying to get cells D2 thro' D71 to turn red if D65 cell formula is 63.0 and to turn yellow if D65 formula is <57.0 Formula in D65 is =D9/D10*D11*50 I have the following conditional formulas set up Formula is =D$65"63.0" Formula is =D$65<"57.0" But it will only turn yellow & seems to do this as soon as I enter data is cell D9 Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting for more than 3 conditions | Excel Worksheet Functions | |||
| More conditions for Conditional Formatting? | Excel Discussion (Misc queries) | |||
| Need 6 Conditions / Conditional Formatting | Excel Worksheet Functions | |||
| Need more than 2 conditions in Conditional Formatting | Excel Worksheet Functions | |||
| more than 3 conditions in conditional formatting - possible? | Excel Discussion (Misc queries) | |||
Linear Mode
