Conditional Formatting In Absolute Number, Highlighted Color

[muhammad susanto]

hi all..

how to make CF formula with condition like this :
in absolute number (20% as parameter)

if C2=>20% - give this cell Red color
if C2=>-20% - give this cell Green color

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]data
[/TD]
[TD]expected result (Hightlighted)
[/TD]
[/TR]
[TR]
[TD]25%
[/TD]
[TD]Red
[/TD]
[/TR]
[TR]
[TD]-25%
[/TD]
[TD]Green
[/TD]
[/TR]
</tbody>[/TABLE]

any help, greatly appreciated..

.sst

 

[Muhammad_Usman]

Its Quit Simple

After Selection you can put two criteria for Highlighted.

1)Select Equal or Greater Then option for 20%
2)Select Less or Equal then Option for -20%

Entered Cell Value to 20% and -20% Simultaneously.
Chose the Color which you want and apply this.

Hope you got it.

 

[Special-K99]

How do you enter -20% on a CF ?

You might have to use the "format only cells that contain" and use the between dropdown
and enter values of -0.2 and 0.2