This question comes up every once in a while; look he
http://www.microsoft.com/office/comm...=en-us&m=1&p=1

Regards,
Ryan---

--
RyGuy


" wrote:

Hi there,
I have created a calendar to help me in my work and I need to
highlight certain dates in different colour pending on if the cell
next to it has a value or not, I have devised 5 values but can only
have a maximum of 3 conditional formatting options.

W = Week end - back ground red - foreground black
B = Bank holiday - background light blue - foreground Black Bold
I = Inset day - Background light yellow - foreground Blue Bold
H = Holiday - Background light gray - foreground Black Bold
D = Half day - background light brown - foreground Blue Bold
X = Tradining day - no change from general settings

assuming that B8 has Value "B" then B8 and C8 background light blue
foreground Black Bold

is it possible?