Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
How do I write the formulas to conditionally format my cells as follows?
Less than or equal to + or - 2% = green Between + or - 2.01% and + or - 3.99% - Yellow Greater than + or - 4% = red |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
In the Conditional Formatting dialog, select "Formula Is". In the adjacent
textbox, enter =ABS(A1)=0.04 Click the Format... button. On the Patterns tab, click the Red color, then OK. In the Conditional Formatting dialog, select Add . Select "Formula Is", and in the adjacent textbox, enter =AND(ABS(A1)0.02,ABS(A1)<0.04) Click the Format... button. On the Patterns tab, click the Yellow color, then OK. In the Conditional Formatting dialog, select Add . Select "Formula Is", and in the adjacent textbox, enter =ABS(A1)<=0.02 Click the Format... button. On the Patterns tab, click the Green color, then OK. Finally, click OK to close the Conditional Formatting dialog. Use the Format Painter to apply this conditional formatting to other cells as desired. Hope this helps, Hutch "pltplt" wrote: How do I write the formulas to conditionally format my cells as follows? Less than or equal to + or - 2% = green Between + or - 2.01% and + or - 3.99% - Yellow Greater than + or - 4% = red |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Thank you, I knew I had to use ABS but I just couldn't get it right. This is
the last step I needed to complete my Performance Improvement Scorecard. Since I set it up for the year I need the cells to stay unformatted when empty. With your help my formula now looks like this. and it works. IF(AND(ABS(A1)<=0.02,A1<"") "Tom Hutchins" wrote: In the Conditional Formatting dialog, select "Formula Is". In the adjacent textbox, enter =ABS(A1)=0.04 Click the Format... button. On the Patterns tab, click the Red color, then OK. In the Conditional Formatting dialog, select Add . Select "Formula Is", and in the adjacent textbox, enter =AND(ABS(A1)0.02,ABS(A1)<0.04) Click the Format... button. On the Patterns tab, click the Yellow color, then OK. In the Conditional Formatting dialog, select Add . Select "Formula Is", and in the adjacent textbox, enter =ABS(A1)<=0.02 Click the Format... button. On the Patterns tab, click the Green color, then OK. Finally, click OK to close the Conditional Formatting dialog. Use the Format Painter to apply this conditional formatting to other cells as desired. Hope this helps, Hutch "pltplt" wrote: How do I write the formulas to conditionally format my cells as follows? Less than or equal to + or - 2% = green Between + or - 2.01% and + or - 3.99% - Yellow Greater than + or - 4% = red |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |