|Sorry for the confused description derby, i just noticed that i got the wrong direction. Forget the problem i mention before. The actualy problem is actually this. For condition formating, my excel spreadsheet was done in 2003 version. however, i'm using the 2007 version now. Is it possible for me to input more than three condition format? For example the one now that i have,|
When the user input a value of 1-3 in B20, a red colour(for 1) green(for 2) brown(for 3) will appear in F21 cell. If a value of of 4 to 7 is applied, another three different colour will appear in F22. Can i do such that the user input of 1-10 can have 10 different colours appear in the output of cell B20?