Saturday, December 7, 2013

Conditional formatting based on numerical values using different color



Right click on a column containing 10 ,20 and 30 and format cells,click custom and type

[BLUE][=>30]00;[MAGENTA][=>20]00;[green]00

and you are done.

you can not change the color of any cell using traditional method