I have to be able to format specific cells with a background colour if they
match a particular condition. I can use Conditional Formatting, but I need
more than 3 format options. Below are the formulae I am want to use
=AND(O$3=$C5,O$3<=$D5) green
=AND(O$3=$F5,O$3<=$G5) grey
=AND(O$3=$I5,O$3<=$J5) blue
=AND(O$3=$L5,O$3<=$M5) yellow

So for example O5 should be green if condition =AND(O$3=$C5,O$3<=$D5) is met.

The outcome is to help with creating a sort of a gant chart. I am sure this
could be done with VB, but I am only just starting out with it. Any pointers
or help with the code would be gratefully received.