What if I have more than 3 conditional format?

  • Thread starter Thread starter Edward Wo
  • Start date Start date
E

Edward Wo

The Excel features "conditional format" which is really useful for viewing,
but it only have 3 format. How can I apply 5 conditional format in one
column.
eg: cell value=1,color=yellow,2 red, 3 green,4 gray, 5 blue.
Any ideas?
 
Back
Top