Conditional formatting limits

Giganews Newsgroups
Subject: Conditional formatting limits
Posted by:  Lucas Lehmer (Lucas.Lehmer.27xuf3_1147846636.6559@excelforum-nospam.com)
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
them!

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

--
Lucas Lehmer
------------------------------------------------------------------------
Lucas Lehmer's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34514
View this thread:http://www.excelforum.com/showthread.php?threadid=542791

Replies