Conditional Formatting with more than three conditions

[vbridge]

I'm trying to create a spreadsheet that changes the color of the cell based on the number that is put into it. The numbers are 1-5. I used the conditional formatting option, but it only allows for three conditions and I need five. What do I do?

Thanks,
Veronica

 

[xlbo]

you could try searching the forum before posting for a start: thread68-223068

found by searching for

"conditional formatting more than three"

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question