View Single Post
  #5   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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 ?