Conditional formatting limits

Giganews Newsgroups
Subject: Conditional formatting limits
Posted by:  Lucas Lehmer (
Date: Wed, 17 May 2006

Hello everyone,

Currently I am working on a spreadsheet with the property that every
cell can take the values 1 through 9.
Now I would like these cell to automatically take another background
color depending on these values (1=yellow ,2=green ,..., 9=black).

My first idea was to solve this problem via conditional formatting, but
apparently Excel does not allow more than 3 conditions, and I need 9 of

Does anyone know a workaround this problem?
Many thanks in advance!

Lucas Lehmer
Lucas Lehmer's Profile:
View this thread: