Quote Originally Posted by Taova

Any suggestions?

Tao
Conditional formatting does not set the colour index of the cell. There are solutions (like VBA Noob's post) but I think the solution is too complex. If you have written a function to colour the cells, they you can write a function to conditionally format the cells. I have done this a few times, and it is really quite straight forward using a select Case statement. You then get unlimited conditional formats. If you format your cells this way, your function will work.

Matt