If your entries are numeric you can get up to 6 font color conditions:
http://www.mcgimpsey.com/excel/conditional6.html
In article ,
yigalb wrote:
I try to auto-color certain values - and I did it with conditional
formatting. Why cant I add 4th and 5th conditions ?