With Excel 2003, only 3 conditions (plus the base formatting).
If you want more than that, either Excel 2007 or VBA
http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm
--
David Biddulph
"Markus" wrote in message
...
I have a annual leave spreadsheet where I want the user to enter a number
from 1-8 which will change the colour of the cell. Is this possible? How
many
conditions can I apply to a cell? I need to apply 8.
Thanks in advance
Markus