Conditional formatting only 3 allowed ????? :(

[davegarland]

My Excel 97 only lets me have 3 differtent conditional formats on the cell. Is there a way of increasing this ?


I want to make each cell a different colour depending on the number and need about 8 number ranges/colours

 

[Ivan F Moala]

On 2002-03-22 10:06, davegarland wrote:
My Excel 97 only lets me have 3 differtent conditional formats on the cell. Is there a way of increasing this ?


I want to make each cell a different colour depending on the number and need about 8 number ranges/colours

Hi Dave, you will have to do this via VBA.
If you do a seach on Conditional Format I'm
sure you will find what you are looking for.
If you require further help on what you have found then post.

Happy Hunting

Ivan