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

data	expected result (Hightlighted)
25%	Red
-25%	Green

<tbody>
</tbody>

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