Variable Format
As a custom format.
[Red][>=100]General;[Blue][<100]General
This will show values >=100 as Red and values <100 as Blue (Excel should add it's General format automatically if other type is not specified)
A total of four formats in total are possible.