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
|