Bob Phillips has an add-in you can download from he

http://www.xldynamic.com/source/xld.....Download.html

This gives you up to 30 conditional formats per cell.

Hope this helps.

Pete

On Apr 9, 2:08*pm, Songoku wrote:
Hi

I have a spreadsheet which contains rosters N for nights D for days OTN for
ovedrtime nights OTD for overtime days AL for anual leave, S for sick
conditional formating will allow me to set three of these conditions. How can
I do this programmatically as to perform the condition and cell colouring?

any help appreciated